select *from table_name where 1=2;

sql query to get zero records from a table having n no of
records

Question Posted / abburi

Answer Posted / abburi

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to rename an existing column in a table? : Sql dba

1082

what is the use of friend function? : Sql dba

1060

What is difference sql and mysql?

1037

What are tables and fields in the database?

1188

How do you modify a table in sql?

1165

What are the methods of filing?

991

What is sql engine in oracle?

1040

What is use of trigger?

987

Enlist the advantages of sql.

1052

What is the main difference between sql and pl/sql?

1149

Can cursors be part of a trigger body?

1693

How to select all records from the table?

1181

Which sorts rows in sql?

1057

What is a recursive stored procedure?

1253

How many indexes can be created on a table in sql?

1114