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 file delimiter?

1108

What is the usage of nvl function?

1044

How can we find duplicate records in a table?

952

What are aggregate and scalar functions?

1032

What is difference between sql function and stored procedure?

1013

What is a native sql query?

1086

What are inner outer left and right joins in sql?

1023

What is sqlerrd?

971

When is the update_statistics command used?

1130

Name the operator which is used in the query for pattern matching?

967

Can triggers stop a dml statement from executing on a table?

1112

how do you know the version of your mysql server? : Sql dba

1010

Differentiate between syntax and runtime errors.

1197

what are the disadvantages of mysql? : Sql dba

1151

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

961