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

Which is better cte or subquery?

712


What is full join in sql?

711


Can we use joins in subquery?

792


What is pl sql quora?

817


What are the differences between implicit and explicit cursors?

699






how to fetch common records from two tables? : Sql dba

839


How is a PL/SQL code compiled?

860


what is the syntax used for partition in tsql? : Transact sql

724


How do you exit in sql?

815


What are the benefits of stored procedures?

705


What is orm in sql?

716


Is sql a dbms?

729


What are the various restrictions imposed on view in terms of dml?

690


What are the types of variables use in pl sql?

686


How many times can we commit in a loop?

737