SELECT * FROM vtable;

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

Question Posted / v

3 Answers
7766 Views
I also Faced
E-Mail Answers

Answer Posted / v

SELECT * FROM vtable;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I update a variable in mysql?

895

What is the default port of mysql server?

986

How do you concatenate strings in mysql?

962

How to enter boolean values in sql statements?

1084

What is the purpose of -> in the mysql terminal?

1056

write a query to mysql in safe mode and to change the root password

922

How can I see connections in mysql?

879

How we can create index in mysql?

934

What is difference between schema and table?

881

Which statement is used in a select query for partial matching?

1152

What is data type for image in mysql?

834

Is mysql better than oracle?

889

How many tables we can create in mysql database?

907

Is sql and mysql same?

875

What is the storage engine for mysql?

921