Discussion :: Introduction to SQL - General Questions (Q.No.16)
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.