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:
all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
16 comments Page 1 of 2.

Mwita said:   2 weeks ago
@All.

Here, We have to know that here there are no any conditions. So all columns will become returned.

Keerthana said:   3 years ago
It's clear for me now. Thank you @Sunil.

Pragalbha Mahajan said:   6 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.

Anil said:   6 years ago
Here, * means select all

Sunil maddheshiya said:   7 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.

Raju Kumar said:   7 years ago
Can anyone explain what is SQL-92 Standard?

Pooja said:   8 years ago
Can anyone explain me which are the SQL standards?

Pavan Kumar said:   1 decade ago
In SQL, we can use the asterik mark(*) to retrive all the table data instead of giving all attribute names in the Query!
SELECT * FROM EMP;

Basha said:   1 decade ago
Yes I Agree with Vijay....

Vijay said:   1 decade ago
Yes I agree with Sundar.


Post your comments here:

Your comments will be displayed after verification.