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
7996 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

What is localhost in mysql?

1060

How would you enter characters as hex numbers?

989

What are procedures in mysql? Explain

1028

What is the usage of ENUMs in MySQL?

1180

What are the steps involved in query processing?

937

How can you filter the duplicate data while retrieving records from the table?

947

How to get a list of all tables in a database?

1105

Which is faster innodb or myisam?

1099

How to show certain selected rows with the value "pcds".

982

Does mysql support nosql?

963

How to dump one database for backup.

986

What is new mysqli?

972

What is a crosstab query?

1009

What are the 5 r's of managing behaviors?

1131

How to use like conditions?

1039