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 2 of 2.
Raju Kumar said:
1 decade ago
Can anyone explain what is SQL-92 Standard?
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)
Anil said:
8 years ago
Here, * means select all
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)
Keerthana said:
5 years ago
It's clear for me now. Thank you @Sunil.
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)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers