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 / v
SELECT * FROM vtable;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How much does mysql cost?
Should I use pdo or mysqli?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How do I save in mysql?
What are mysql data types?
What is pdo in php mysql?
How to get help information from the server?
Why phpmyadmin is used for mysql?
What are the three types of queries?
Is mysql workbench a dbms?
what is constraints?
What is a join? Explain the different types of mysql joins.
How to find second highest salary from a table?
What do we use to remove duplicate records while fetching a data in mysql ?
Why do we need mysql?