Select * From Table_Name Where 1 = 2;

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

Question Posted / ketul

Answer Posted / ketul

Is This Answer Correct ?

46 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to take user input in pl sql?

1153

What is the difference between in and between in sql?

1051

What is the difference between database trigger and stored procedure?

1066

How do I start pl sql?

941

How do I view tables in sql developer?

930

what is offset-fetch filter in tsql? : Transact sql

938

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1179

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

945

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

1204

how to use myisamchk to check or repair myisam tables? : Sql dba

964

What is embedded sql what are its advantages?

1030

What is error ora-01000: maximum open cursors exceeded

1133

How is a process of pl/sql compiled?

1143

In what condition is it good to disable a trigger?

1001

Explain the difference between sql and mysql.

1055