sql query to get zero records from a table having n no of records

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

sql query to get zero records from a table having n no of
records

Question Posted / jahangir

8 Answers
25628 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 having n no of records..

Answer / ketul

Select * From Table_Name Where 1 = 2;

Is This Answer Correct ?

46 Yes

4 No

sql query to get zero records from a table having n no of records..

Answer / giri

Select * From Table_Name Where 1 = 2;

Is This Answer Correct ?

12 Yes

0 No

sql query to get zero records from a table having n no of records..

Answer / abburi

select *from table_name where 1=2;

Is This Answer Correct ?

9 Yes

0 No

sql query to get zero records from a table having n no of records..

Answer / xyz

select * from emp minus
select * from emp;

Is This Answer Correct ?

12 Yes

4 No

sql query to get zero records from a table having n no of records..

Answer / krishan

yes

Is This Answer Correct ?

7 Yes

3 No

sql query to get zero records from a table having n no of records..

Answer / welcomeashwin

SELECT * FROM TABLE_NAME WHERE 1 = 2;

Is This Answer Correct ?

3 Yes

0 No

sql query to get zero records from a table having n no of records..

Answer / mallik

select * from table_name where rownum < n -(n-1)

--where 'n' is no of rows.

Is This Answer Correct ?

3 Yes

1 No

sql query to get zero records from a table having n no of records..

Answer / siri

select * from table_name where 1=0;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer