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 denormalization. : Sql dba

759

What is #table in sql?

701

How do I delete a trigger?

720

How would you reference column values before and after you have inserted and deleted triggers?

808

What are the 3 modes of parameter?

859

what are aggregate and scalar functions? : Sql dba

727

Can unique keys be null?

655

What are types of joins?

697

Explain the insert into statements in sql?

723

What are some emotional triggers?

745

What is pl sql commands?

728

How long will it take to learn pl sql?

684

How do I view a table in sql?

713

Can we use having without group by in sql?

728

Can we create a trigger on view?

662