Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

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

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

What is a session in mysql?

0 Answers  

Should I use pdo or mysqli?

0 Answers  

What is mysql default database?

0 Answers  

What is mysql in linux?

0 Answers  

What is difference between statement and preparedstatement?

0 Answers  

How do I select a table in mysql?

0 Answers  

What is the difference between char and varchar in mysql?

0 Answers  

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

0 Answers  

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 Answers  

Consider you have the following three tables which have to be linked together.

0 Answers  

How do I clear the command in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories