Which one of the following is the correct way to select all columns and all ro

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

3 Answers
6401 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which one of the following is the correct way to select all columns and all rows from "vtable..

Answer / sapin

Choice 5

Is This Answer Correct ?

9 Yes

0 No

Which one of the following is the correct way to select all columns and all rows from "vtable..

Answer / sapin

SELECT * FROM vtable WHERE 1 = 1

Is This Answer Correct ?

2 Yes

0 No

Which one of the following is the correct way to select all columns and all rows from "vtable..

Answer / v

SELECT * FROM vtable;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer