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

Why do we use preparedstatement?

928

What are the similarities between a function and a procedure?

896

Can mysql and mariadb coexist?

1094

How to get help information from the server?

1053

Is mysql free for enterprise?

895

What is difference between oracle sql and mysql?

1019

How to print message in mysql trigger?

1513

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2833

How can we optimize stored procedure?

951

How many TRIGGERS are allowed in MySql table?

1083

How to return query output in xml format?

1034

What is mysql_pconnect?

904

What is database clustering in mysql?

1036

What is session variable in mysql?

979

What is mysql root?

952