select * from table_name where 1=0;

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

Question Posted / siri

Answer Posted / siri

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are predefined functions in sql?

1042

how to select first 5 records from a table? : Sql dba

977

Can I call a procedure inside a function?

1011

What is implicit cursor in pl sql?

1090

what are the different type of normalization? : Sql dba

1027

Is sql dba a good career? : SQL DBA

991

Explain two easy sql optimizations.

1009

What is mdf ldf and ndf?

1002

what is meant by nl2br()? : Sql dba

1044

What is sql constant?

1033

Explain the advantages and disadvantages of stored procedure?

1148

difference between anonymous blocks and sub-programs.

1134

What is sql architecture?

1048

what is transaction? : Sql dba

1007

Is the primary key an index?

1026