SELECT * from TABLE WHERE 1 = 2;

sql query to get zero records from a table

Question Posted / biswajit ghosh

Answer Posted / biswajit ghosh

SELECT * from TABLE
WHERE 1 = 2;

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is program global area (pga) in oracle?

1030

How to synchronize 2 schema's objects?

2181

What is oracle analytical function?

1141

What do you understand by a database object? Can you list a few of them?

1018

How to count duplicated values in a column in oracle?

1039

What are the differences between char and nchar in oracle?

1095

How to write a left outer join with the where clause in oracle?

1084

How do we represent comments in oracle?

1048

How to define and use table alias names in oracle?

941

How do we get field details of a table?

978

What is flashback in Oracle?

1017

How to write a query with a right outer join in oracle?

1168

How to install oracle odbc drivers?

1093

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1114

Explain the use of full option in exp command.

1116