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

Explain joins in oracle?

989

How to assign a table row to a record variable?

980

What is oracle rownum?

897

What is format trigger?

2026

State and explain the different types of data models?

907

How to use subqueries with the exists operator in oracle?

982

What is the difference between translate and replace?

1020

What is bulk collect in oracle?

965

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1824

What privilege is needed for a user to query tables in another schema?

935

Give the advantages and disadvantages of clusters.

1004

Which are the five query types available in oracle?

917

What types of joins are used in writing subqueries?

946

How do I call oracle stored procedures that take no parameters?

1041

What is a sub query and what are the different types of subqueries?

1085