Database - Introduction to SQL - Discussion

Discussion :: 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:

[A]. all columns of the table are to be returned.
[B]. all records meeting the full criteria are to be returned.
[C]. all records with even partial criteria met are to be returned.
[D]. None of the above is correct.

Answer: Option A

Explanation:

No answer description available for this question.

Shruti Chouksey said: (Dec 1, 2010)  
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: (Jan 27, 2011)  
A) is correct . because, all columns values will be returned.

Aniket said: (Aug 30, 2011)  
SELECT * FROM STUDENT WHERE AGE=19;

Here when criteria get satisfied.
Those records get selected...
So i think option 2 is right....

Sundar said: (Sep 23, 2011)  
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: (Sep 29, 2011)  
Ya I agree with sundar.

Purnendra Kushwaha said: (Sep 30, 2011)  
Yes I m also agree with bhavika.

Vijay said: (Oct 25, 2011)  
Yes I agree with Sundar.

Basha said: (Oct 26, 2011)  
Yes I Agree with Vijay....

Pavan Kumar said: (Dec 23, 2011)  
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;

Pooja said: (Jul 25, 2015)  
Can anyone explain me which are the SQL standards?

Raju Kumar said: (Aug 25, 2015)  
Can anyone explain what is SQL-92 Standard?

Sunil Maddheshiya said: (Jul 2, 2016)  
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.

Anil said: (Mar 20, 2017)  
Here, * means select all

Pragalbha Mahajan said: (Jun 29, 2017)  
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.

Keerthana said: (Jun 8, 2020)  
It's clear for me now. Thank you @Sunil.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.