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.
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)
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)
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.
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;
SELECT * FROM EMP;
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....
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...
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)
M.VINOTHKUMAR said:
1 decade ago
A) is correct . because, all columns values will be returned.
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?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers