select * from table_name where rownum

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

Question Posted / mallik

Answer Posted / mallik

select * from table_name where rownum < n -(n-1)

--where 'n' is no of rows.

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a rank in sql?

952

How to order siblings in oracle hierarchy queries?

1032

What is integrity in sql?

1031

Is it possible to update views?

952

Explain the order of sql statement execution?

1037

How do sql databases work?

988

what are the authentication modes in sql server? : Sql dba

1056

How is a PL/SQL code compiled?

1215

What is mutating error?

959

What does seeding a database mean?

949

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1120

What are some emotional triggers?

973

What types of commands can be executed in sql*plus?

1101

explain about mysql and its features. : Sql dba

1008

Does inner join remove duplicates?

932