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

how many sql dml commands are supported by 'mysql'? : Sql dba

1058

How to avoid using cursors?

1041

What is the use of sql trace?

897

How exception is different from error?

971

How to take user input in pl sql?

1107

What are the various restrictions imposed on view in terms of dml?

911

What are the parts of a basic sql query?

920

What is union and union all keyword in sql?

972

Can I learn sql in a week?

1008

What is scalar function in sql?

979

What is the starting oracle error number?

999

What is meaning of <> in sql?

1023

What are aggregate and scalar functions?

978

what is a view? : Sql dba

1030

What will you get by the cursor attribute sql%found?

901