select * from table_name where 1=0;

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

Question Posted / siri

8 Answers
25637 Views
CTS, I also Faced
E-Mail Answers

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

What is trigger and types?

968

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1127

Write a query to display the current date in sql?

969

What is the trigger in sql?

905

What is oracle and pl sql?

1081

What is mutating table error?

1118

What is sqlerrd?

922

How to select random rows from a table?

1023

What is a field in a database?

1006

Can there be 2 primary keys in a table?

952

What are some predefined exceptions in pl/sql?

1067

What is multiple partition?

921

What is %type in pl sql?

926

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1788

what is data manipulation language? : Sql dba

949