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

What are the basic sql commands?

1086

What is procedure explain with program?

1011

How do I install microsoft sql?

1043

What is pl sql and why it is used for?

1109

Does inner join remove duplicates?

934

Are sql connections encrypted?

1016

Explain what is table in a database?

1055

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1045

Can we insert data into view?

895

Why plvtab is considered as the easiest way to access the pl/sql table?

1207

What is a primary key called that is made up of more than one field?

1339

What are its different types of dbms?

998

What does rownum mean in sql?

1017

How do I edit a trigger in sql developer?

990

what is 'mysqlimport'? : Sql dba

1041