Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 16)
16.
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Discussion:
16 comments Page 1 of 2.
Sunil maddheshiya said:
9 years ago
Sql-92 was the third edition of SQL database query language. The later version of SQL is,
> SQL-99, SQL-2003, SQL-2008, SQL-2011.
And * means it will return all column of a table whether all record meets full criteria or not.
> SQL-99, SQL-2003, SQL-2008, SQL-2011.
And * means it will return all column of a table whether all record meets full criteria or not.
(2)
Pragalbha Mahajan said:
8 years ago
Some are saying option 2 is right with the following example.
SELECT * FROM STUDENT WHERE AGE=19;.
Here when criteria get satisfied.
Those records get selected.
So option 2 is right.
BUT let me clear them this query will also return all columns of table with age 19.
And second option is about records NOT columns.
SELECT * FROM STUDENT WHERE AGE=19;.
Here when criteria get satisfied.
Those records get selected.
So option 2 is right.
BUT let me clear them this query will also return all columns of table with age 19.
And second option is about records NOT columns.
(1)
Mwita said:
3 years ago
@All.
Here, We have to know that here there are no any conditions. So all columns will become returned.
Here, We have to know that here there are no any conditions. So all columns will become returned.
(1)
Shruti Chouksey said:
1 decade ago
In this question 2nd and 3rd option is right because when we use * so we can all the Records with all coloums...
M.VINOTHKUMAR said:
1 decade ago
A) is correct . because, all columns values will be returned.
ANIKET said:
1 decade ago
SELECT * FROM STUDENT WHERE AGE=19;
Here when criteria get satisfied.
Those records get selected...
So i think option 2 is right....
Here when criteria get satisfied.
Those records get selected...
So i think option 2 is right....
Sundar said:
1 decade ago
The given answer is correct. Don't get confused. The questions is asked about only about *, not about whether the corresponding select query has any Where condition or any other limitations.
Bhavika said:
1 decade ago
Ya I agree with sundar.
Purnendra kushwaha said:
1 decade ago
Yes I m also agree with bhavika.
Vijay said:
1 decade ago
Yes I agree with Sundar.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers