SELECT * FROM TABLE_NAME WHERE 1 = 2;

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

Question Posted / welcomeashwin

Answer Posted / welcomeashwin

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how can we repair a mysql table? : Sql dba

988

Explain table and field in sql?

1068

How do you identify a primary key?

1067

how to create a new view in mysql? : Sql dba

943

Which type of cursor is used to execute the dml statement?

962

What sql does db2 use?

986

Can we join 3 tables in sql?

1049

What packages are available to pl/sql developers?

1068

What is the difference between an inner and outer join?

1020

When is a declare statement required?

1146

What are sql functions? Describe the different types of sql functions?

1147

How do sql databases work?

1004

What are three advantages to using sql?

1025

what is the syntax used for partition in tsql? : Transact sql

1019

What is the max nvarchar size?

985