distinct

SELECT DISTINCT "column_name"
FROM "table_name"

The SELECT keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily mean that there will be redundancies. What if we only want to select each DISTINCT element? This is easy to accomplish in SQL. All we need to do is to add DISTINCT after SELECT.

where

SELECT "column_name"
FROM "table_name"
WHERE "condition"

this will show the results as we specify in where clause
like a particular name, or employess of particular age

it will be like

select name from employee
where age=21;

it will show name of all employees of age 21

SQL commands: select

SELECT "column_name" FROM "table_name"

the two keywords that are used are column name and table name:

that will select the particular information from the table...

a particular example can be

select name from employee;

which will show all the names of employees from the employee table....