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.