select * from table_name where 1=0;

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

Question Posted / siri

Answer Posted / siri

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to calculate the difference between two dates? : Sql dba

1112

What is compilation error in pl sql?

1023

What are the properties of a transaction?

1185

How many types of tables are there?

996

How do you declare a variable in pl sql?

1069

What is the best sql course?

1026

What does select count (*) mean in sql?

1073

Explain the difference between drop and truncate commands in sql?

1108

Can triggers stop a dml statement from executing on a table?

1157

Is sqlexception checked or unchecked?

1009

What is trigger types in sql?

1043

Can we change the table name in sql?

1000

What is on delete set null?

1135

Does oracle roll back the transaction on an error?

1067

How run sql*plus commands that are stored in a local file?

1113