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

Answer Posted / abburi

select *from table_name where 1=2;

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mutating error?

693


What are analytic functions in sql?

734


What are the different set operators available in sql?

751


How many scalar data types are supported in pl/sql?

708


what is bcp? When does it used? : Sql dba

694






What is dialect in sql?

694


What is cold data?

672


What is the difference between clustered and non-clustered indexes?

794


Is it possible to update views?

706


What is exit statement?

738


What is difference sql and mysql?

695


Can triggers stop a dml statement from executing on a table?

797


Mention what problem one might face while writing log information to a data-base table in pl/sql?

867


How does sql store data?

656


What are sql built in functions?

669