sql query to get zero records from a table

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / jahangir

7 Answers
11657 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

sql query to get zero records from a table..

Answer / kishor

Select * from table where 1 = 2

Is This Answer Correct ?

29 Yes

2 No

sql query to get zero records from a table..

Answer / biswajit ghosh

SELECT * from TABLE
WHERE 1 = 2;

Is This Answer Correct ?

8 Yes

1 No

sql query to get zero records from a table..

Answer / vawani sankar naik

SELECT * FROM TABLE WHERE 1=2;

Is This Answer Correct ?

7 Yes

0 No

sql query to get zero records from a table..

Answer / nathan

Select count(*) from emp where 1 = 2

Is This Answer Correct ?

0 Yes

0 No

sql query to get zero records from a table..

Answer / nanne

Your Question is not clear..i believe that your expecting retrieve the tables which are having zero rows in the database.

Yes...we can retrieve the zero rows tables from DB

Select * from dba_tables
where num_rows = 0;

Regards,
Nanne

Is This Answer Correct ?

0 Yes

0 No

sql query to get zero records from a table..

Answer / vipul.solanki

select * from menu_master where rownum <1;

Is This Answer Correct ?

1 Yes

2 No

sql query to get zero records from a table..

Answer / neha_gupta

select null from emp

Is This Answer Correct ?

1 Yes

10 No

Post New Answer