Database - Introduction to SQL - Discussion

Where basically used to filter Records(Rows).

select * from emp where ename='smith';

So, Here we are putting Restriction on the rows only.

The WHERE clause is used to extract only those records that fulfill a specified criterion.

Eg: customers from the country "India", in the "Customers" table

SELECT * FROM Customers
WHERE Country='India';

WHERE basically used to filter Records(Rows).
when we write,

select * from student where city='Indore'

So, Here we are putting Restriction on the rows of a column city.

Actually the WHERE clause is used to extract only those data's that fulfills a specified criterion. It is used on row operation. E.g:

SELECT column_name(s)
FROM table_name
WHERE column_name sal value

Where class is used to retrieve row data from the table.

Suppose we have a one emp table that contains some columns if we want get the information of empid 234 so we have to write,

SELECT * from emp where Empid=234.

View is used to limit the column.

By using where clause we can retrive the records which are satisfied the conditions...

In where clause we use the condition on the row tuple.

Because in where clause we use the condition on the row tuple and not on the coloum. So b is correct ans.

Hi friends.

First of all I thank this site for giving a wonderful info about what we need exactly!

The column name (s) is the name (s) of the column which we need to retrieve the data.

We'll restrict some values which we do not need know such values are row data.

For example:.

Select emp_id, emp_name from employees.

Where emp_id IN (10, 20, 30, 40, 50) ;.

Here emp_id, emp_name are column datas and the data which we retrieve is called as row data.

So row data oly restricted.