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

Answer Posted / ketul

Select * From Table_Name Where 1 = 2;

Is This Answer Correct ?    46 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database white box testing and black box testing?

848


what is the difference between $message and $$message? : Sql dba

735


How can you save or place your msg in a table?

697


How do I truncate a sql log file?

731


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

779






Why we use joins in sql?

715


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

804


Why left join is used in sql?

694


Which is better join or subquery?

788


Is and as keyword in pl sql?

682


What is difference between ms sql and mysql?

655


How to combine two stored procedures in sql?

798


What are the types of records?

735


Can we use having without group by in sql?

730


What is the use of <> sql?

733