Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 3)
3.
The SQL WHERE clause:
Discussion:
27 comments Page 3 of 3.
ASHISH PRAJAPATI said:
1 decade ago
Where clause provoide restriction such as how many row are retrive that specify by where clause.
NARENDRA said:
1 decade ago
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
IF YOU SELECT COLUMN1, COLUMN2 IT'S SHOWS ALL ROW AND IF YOU DONE THIS WITH WHERE IT'S SHOW LIMIT ROW
Himani Agarwal said:
1 decade ago
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.
Pradeep said:
1 decade ago
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.
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.
Swopna said:
1 decade ago
I can't understand. Anyone please explain it. I too have a doubt.
Anil said:
1 decade ago
Where is a active transformation which changes the number of rows.
Iftikhar said:
1 decade ago
Please Explain. I have Doubt.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers