Select * From Table_Name Where 1 = 2;

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

Question Posted / giri

Answer Posted / giri

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is data type in database?

927

State some properties of relational databases?

1001

what are the different tables present in mysql? : Sql dba

922

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

967

Does view store data in sql?

896

What is the difference between the conventional and direct path loader? : aql loader

1108

What is where clause in sql?

980

What is scalar function?

998

How to Execute a Package in PL/SQL.?

1106

What is a scalar value in sql?

1010

How do you declare a variable in pl sql?

964

What is Collation Sensitivity ? What are the various type ?

901

What do you mean by rowid?

911

What is the difference between delete, truncate and drop command?

1053

How do you optimize a stored procedure query?

936