Which one of the following is the correct way to select all
columns and all rows from "vtable"?
Choice 1
SELECT FROM vtable SELF JOIN vtable
Choice 2
SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = *
Choice 3
SELECT EVERYTHING FROM vtable
Choice 4
SELECT vtable.* WHERE vtable = vtable
Choice 5
SELECT * FROM vtable WHERE 1 = 1
Answer Posted / sapin
SELECT * FROM vtable WHERE 1 = 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you filter the duplicate data while retrieving records from the table?
Which is faster mysql or mongodb?
What, if a table has one column defined as TIMESTAMP?
How important is to list the column names when doing an insert?
How can I change database in mysql?
What are all the Common SQL Function?
How can you change the password of a mysql user?
Is oracle mysql free?
What's the difference between mysql and sql server?
What is the command line end user interface - mysql?
Why do we use group by and order by function in mysql?
How to do login in mysql with unix shell.
Is mysql a database?
Explain the difference between primary key and candidate key in mysql?
What is the function of mysqldump?