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

Is primary key a clustered index?

914

Give the order of sql select?

1089

What is offset and limit in sql?

1002

What is the difference between sql and mysql?

1055

How to add, remove, modify users using sql?

980

Is sql free?

889

Does sql*plus also have a pl/sql engine?

1039

what is isam? : Sql dba

953

How many functions are there in sql?

964

Cite the differences between execution of triggers and stored procedures?

1031

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

What is keys and its types?

1022

What do you understand by pl/sql records?

961

what is schema? : Sql dba

987

What is the use of primary key?

953