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

Answer Posted / siri

select * from table_name where 1=0;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why select is used in sql?

514


How can you select unique records from a table?

518


What are the sql aggregate functions?

602


how can you create an empty table from an existing table? : Sql dba

656


What is a subquery in sql?

505






How do I add a database to sql?

573


How can we find duplicate records in a table?

512


what is a unique key ? : Sql dba

541


how to concatenate two character strings? : Sql dba

550


What is having clause in sql?

527


List different type of expressions with the example.

546


What is record variable?

549


what is myisam? : Sql dba

574


How much does sql certification cost?

543


What is the difference between having clause and where clause?

563