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 is a temporal table?

930

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1001

what are tables and fields? : Sql dba

1051

what is sql? : Sql dba

1028

Why are aggregate functions called so?

946

What is the maximum number of rows in sql table?

1030

Define SQL and state the differences between SQL and other conventional programming Languages?

1210

What is the use of sql trace?

952

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1059

How do I run a program in pl sql?

1002

What is a table?

1014

What is a nested table in word?

957

How do you modify a trigger?

926

What is difference between rank () row_number () and dense_rank () in sql?

1101

how to drop an existing view in mysql? : Sql dba

1060