SELECT * FROM vtable WHERE 1 = 1

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 / sapin

3 Answers
7874 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

Please Help Members By Posting Answers For Below Questions

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

890

Which is faster mysql or mongodb?

909

What, if a table has one column defined as TIMESTAMP?

1005

How important is to list the column names when doing an insert?

1036

How can I change database in mysql?

885

What are all the Common SQL Function?

1125

How can you change the password of a mysql user?

956

Is oracle mysql free?

866

What's the difference between mysql and sql server?

983

What is the command line end user interface - mysql?

1077

Why do we use group by and order by function in mysql?

914

How to do login in mysql with unix shell.

1103

Is mysql a database?

939

Explain the difference between primary key and candidate key in mysql?

959

What is the function of mysqldump?

1070