sql query to get zero records from a table having n no of
records
Answers were Sorted based on User's Feedback
Answer / mallik
select * from table_name where rownum < n -(n-1)
--where 'n' is no of rows.
Is This Answer Correct ? | 3 Yes | 1 No |
what is error ora-03113: end-of-file on communication channel?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
Which language is used in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
Is natural join same as inner join?
What is a rank in sql?
how to debugg a procedure or package using dbms_output.put_line in plsql
What is the purpose of a sql?
How do you remove duplicates without using distinct in sql?
How many levels can subqueries be nested in a FROM clause?
What does partition by mean in sql?
Explain table and field in sql?