Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.3)

3. 

The SQL WHERE clause:

[A]. limits the column data that are returned.
[B]. limits the row data are returned.
[C]. Both A and B are correct.
[D]. Neither A nor B are correct.

Answer: Option B

Explanation:

No answer description available for this question.

Iftikhar said: (Nov 27, 2010)  
Please Explain. I have Doubt.

Anil said: (Dec 3, 2010)  
Where is a active transformation which changes the number of rows.

Swopna said: (Jan 30, 2011)  
I can't understand. Anyone please explain it. I too have a doubt.

Pradeep said: (Mar 5, 2011)  
Where clause is used to retrive appropriate rows from a large amount of data.

Ex: in emp table it has a 14 rows, but I want to retrive paticular data consists of emp is 7902, at taht time we use where clause. Select * from emp where emp=7902.

Himani Agarwal said: (Mar 17, 2011)  
How can where puts a limitation on column it can only check for the conditions and display rows accordingly. The columns can only be specified with select clause.

Narendra said: (Apr 29, 2011)  
WHERE CLAUSE ONLY LIMIT ROW NOT COLUMN
IF YOU SELECT COLUMN1, COLUMN2 IT'S SHOWS ALL ROW AND IF YOU DONE THIS WITH WHERE IT'S SHOW LIMIT ROW

Ashish Prajapati said: (May 12, 2011)  
Where clause provoide restriction such as how many row are retrive that specify by where clause.

Arjun said: (Jul 24, 2011)  
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.

Jyoti said: (Sep 5, 2011)  
Because in where clause we use the condition on the row tuple and not on the coloum. So b is correct ans.

Shilpashree said: (Sep 5, 2011)  
In where clause we use the condition on the row tuple.

Manche Shekhar said: (Nov 3, 2011)  
By using where clause we can retrive the records which are satisfied the conditions...

Raku said: (Dec 30, 2011)  
View is used to limit the column.

Vani said: (Jul 4, 2012)  
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.

Rahul Kumar said: (Mar 5, 2013)  
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

Gourav Agrawal said: (May 1, 2013)  
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.

Arati said: (Jul 31, 2013)  
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';

Brahmmisoft said: (Aug 11, 2014)  
Where basically used to filter Records(Rows).

select * from emp where ename='smith';

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

Adane said: (Nov 11, 2014)  
What is the difference between SQL and ORACLE?

Kuntee Kurre said: (Nov 15, 2014)  
Where clause is used to limit the row. If I want to display only those student name who achieve greater than 80 then we limit the row.

Shibani said: (Jan 14, 2015)  
Can we write the syntax as:

select 'ename' from records where salary>260000;

Where records is table name and ename is employee name why not?

Sat said: (Jun 18, 2015)  
Anyone please tell me about column restriction? How is it possible with example?

Pauline said: (Jul 9, 2015)  
Where clause specifies which records should be updated. E.g give me all the records of all the students who are 18 yrs. The WHERE clause is synonymous to"who are 18 yrs".

Sanjib said: (Sep 9, 2016)  
Where clause is used to invoke index.

Karthi said: (Apr 28, 2018)  
The where clause is used to check the condition.

Based on the condition, we can select some specific records from the table and we can update some specific records in the table, and also we can delete some specific records from the table.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.