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

How much does mysql cost?

907

Should I use pdo or mysqli?

899

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

973

How do I save in mysql?

961

What are mysql data types?

994

What is pdo in php mysql?

939

How to get help information from the server?

1043

Why phpmyadmin is used for mysql?

933

What are the three types of queries?

907

Is mysql workbench a dbms?

1002

what is constraints?

1144

What is a join? Explain the different types of mysql joins.

1384

How to find second highest salary from a table?

1018

What do we use to remove duplicate records while fetching a data in mysql ?

961

Why do we need mysql?

968