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 |
How do we use distinct statement? What is its use?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
what is global variable in pl/sql
select sal from emp group by sal
how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
How does postgresql compare to mysql?
what is the cursor and use of cursor in pl/sql ?
Explain the usage of WHERE CURRENT OF clause in cursors ?
Which is better join or subquery?
How do I count rows in sql?
Can a select statement fire a trigger?
Can we rename a column in the output of sql query?