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

Answer Posted / welcomeashwin

SELECT * FROM TABLE_NAME WHERE 1 = 2;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are enums used for in mysql? : Sql dba

610


How can we optimize a sql query?

571


How many types of index are there?

551


What are the possible values that can be stored in a boolean data field?

513


What is a unique key?

585






How many rows can sqlite handle?

583


how to rename an existing table in mysql? : Sql dba

572


what is “go” in t-sql? : Transact sql

598


What is the command used to fetch the first 5 characters of a string?

704


What is partition in sql query?

515


What is vector point function?

562


how to use regular expression in pattern match conditions? : Sql dba

522


what is a join? : Sql dba

561


What are the three pl sql block types?

571


What is lookup table in sql?

601