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 difference between mysql and postgresql?

511

What is compiled query?

516

what are all the different types of indexes? : Sql dba

526

Explain unique key in sql.

561

Is sql free?

499

Can a trigger call a stored procedure?

534

What is pl sql package?

591

how to check server status with 'mysqladmin'? : Sql dba

566

what is rdbms? : Sql dba

573

What is mdf ldf and ndf?

558

Why do we use partitions in sql?

545

What is the difference between clustered and non-clustered index in sql?

519

What are sql commands?

500

Can we join 3 tables in sql?

494

Does inner join return duplicate rows?

518