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 difference between pl and sql?
What is procedure explain with example?
What does over partition by mean in sql?
Mention what is the plv (pl/vision) package offers?
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
How delete all data from all tables in sql?
What is autocommit sql?
Why procedure is used in sql?
What are different types of statements supported by sql?
what is query cache in mysql? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
I want to know the difference between A Record Type and a Table.