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 are properties of the transaction?

554


Is progress software supports to ( pl/sql )?

526


what are set operators in sql? : Sql dba

534


What type of database is sql?

613


What is case function?

596






How do I view a procedure in sql?

547


What is function and procedure in pl sql?

517


Why do we need cursor in pl sql?

645


How to avoid duplicate records in a query?

575


What is the size of partition table?

551


What is java sql drivermanager?

546


is it possible to pass an object or table to a procedure as an argument?

567


how to enter binary numbers in sql statements? : Sql dba

487


What is 19 null in sql?

532


What is attribute indicator in pl sql?

523