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.
Mwita said:
2 weeks 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.
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.
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.
> 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;
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:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers