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

How to initialize variables with default values?

1305

Can a formula column referred to columns in higher group ?

2550

How do I learn what codesets are available in oracle?

1077

What is not equal to in oracle?

1047

How to define an anonymous procedure with variables?

1238

Why cursor variables are easier to use than cursors?

1137

How to run create database statement again?

1218

What are joins, explain all types of joins?

2360

Explain compound trigger in oracle?

1088

what is IDE,DMV in sql server?

2878

what is port in oracle? how is it related to database application.

1991

State all possible different index configurations a table can possibly have?

1100

What to do if dba lost the system password?

1244

What is bulk collect in oracle?

1053

What are the varoius components of physical database structure of oracle database?

1039