IndiaBIX

Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 16)
Introduction to SQL
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 2 of 2.
Basha said:   1 decade ago
Yes I Agree with Vijay....
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;
Pooja said:   1 decade ago
Can anyone explain me which are the SQL standards?
Raju Kumar said:   1 decade ago
Can anyone explain what is SQL-92 Standard?
Anil said:   8 years ago
Here, * means select all
Keerthana said:   5 years ago
It's clear for me now. Thank you @Sunil.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers