Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7722 Views
- I also Faced
- E-Mail Answers
Answer Posted / sapin
SELECT * FROM vtable WHERE 1 = 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the current root password of mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How do I install mysql on windows 10?
What is default password for mysql?
How do I install and use mysql?
What is ISAM?
What is mysql connector used for?
How to use sum function in where clause in mysql?
How can you plan the logshipping before processing?
What is mysql used for?
What is the difference between now() and current_date()?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What is unsigned in mysql?
What is offset limit?
What are the types of database engines available in mysql?
