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 system tablespace?

1042

How to recover a dropped table in oracle?

983

How to use "in out" parameter properly?

998

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

1110

What do you understand by a database object?

987

various types of hints and their usage

2623

What are joins, explain all types of joins?

2219

How to check the oracle tns settings?

989

What is a trigger and what are its types?

1113

What are the original export and import utilities?

1056

Give syntax for SQL and ORACLE joins.

1040

What is a user role in oracle?

1063

What is the dynamic sql in oracle?

1007

How to run queries on external tables?

988

How to work with data objects interactively?

924