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 the use of double ampersand (&&) in sql queries?

629


Why should I use postgresql?

568


How to use transactions efficiently : transact sql

552


Can you do multiple joins in sql?

552


What does cursor do in sql?

524






Which is better varchar or nvarchar?

552


Can variables be used in sql statements?

556


What is the best partition size for windows 10?

489


What is the usage of distinct keyword?

636


what is difference between delete and truncate commands? : Sql dba

584


what is blob? : Sql dba

564


What does subquery mean in sql?

545


How do you remove duplicates without using distinct in sql?

508


Is a view faster than a stored procedure?

551


What is the use of pl/sql table?

559