sql query to get zero records from a table

Answer Posted / vawani sankar naik

SELECT * FROM TABLE WHERE 1=2;

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to export your own schema?

566


What is a synonym? What are its various types?

620


What is different types of joins?

567


What is the order of defining local variables and sub procedures/functions?

595


What is ceil and floor in oracle?

567






Explain the use of control file?

650


Point out the difference between user tables and data dictionary?

536


How to use "if" statements on multiple conditions?

714


How to pass parameters to procedures in oracle?

566


Can we commit inside a function in oracle?

552


What is max rowid in oracle?

551


Please explain joins in oracle?

545


Explain a synonym?

594


How to call a stored function with parameters?

559


Query to retrieve record for a many to many relationship ?

2077