Select * From Table_Name Where 1 = 2;

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

Question Posted / giri

8 Answers
25897 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / giri

Select * From Table_Name Where 1 = 2;

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do we need to check in database testing?

1010

What is the maximum number of rows in sql table?

1017

What is rownum?

970

What is sql comments?

1068

Can you rollback after commit?

973

Does sql between include endpoints?

991

what is 'trigger' in sql? : Sql dba

1075

What is foreign key and example?

925

How to use sql statements in pl/sql?

1110

What are the different types of a subquery?

1044

What is data modelling in sql?

1009

What are joins in sql?

1036

What are the types of queries in sql?

1075

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2012

What is Histogram?

1554