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

More MySQL Interview Questions

How is myisam table stored?

0 Answers

What is 'mysqlcheck'?

0 Answers

What is regex in mysql?

0 Answers

What are the types of index?

0 Answers

How to rename an existing table in mysql?

0 Answers

What is the difference between myisam dynamic and myisam static in mysql?

0 Answers

Does mysql automatically index foreign keys?

0 Answers

What are the types of database engines available in mysql?

0 Answers

What is full text indexing in mysql?

0 Answers

Is mysql workbench a dbms?

0 Answers

What you can use regular expression for in mysql?

0 Answers

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers

For more MySQL Interview Questions Click Here