Advertisement Remove all ads

Give any two basic commands of SQL. - Accounts

Advertisement Remove all ads
Advertisement Remove all ads
Answer in Brief

Give any two basic commands of SQL.

Advertisement Remove all ads

Solution

Structural Query Language (SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can this language to create a database. SQL users certain commands like Create, Drop, Insert, etc. to carry out the required tasks.

The Basic Commands of SQL are explained as follows:

(1) Select: These statements are used to fetch data from a database. Every query will begin with Select.

SELECT column_name
FROM table_name;

(2) Where: It is a clause that indicates you want to filter the result set to include only rows where the following condition is true.

SELECT column_name(s)
FROM table_name
WHERE column_name operator value;

(3) And: It is an operator that combines two conditions. Both conditions must be true for the row to be included in the result set.

SELECT column_name(s)
FROM table_name
WHERE column_1 = value_1
AND column_2 = value_2;

(4) Update: These statements allow you to edit rows in a table.

UPDATE table_name
SET some_column = some_value
WHERE some_column = some_value;

Concept: Features of Database Management System (DBMS)
  Is there an error in this question or solution?
Advertisement Remove all ads

Video TutorialsVIEW ALL [1]

Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×