sql query to get zero records from a table having n no of
records
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 |
Post New Answer View All Answers
what is offset-fetch filter in tsql? : Transact sql
What steps server process has to take to execute an update statement?
What are the different types of joins in sql?
What are pl sql procedures?
What does the argument [or replace] do?
What is the difference between syntax error and runtime error?
What is the difference between rename and alias?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
what happens if null values are involved in expressions? : Sql dba
what is the stuff function and how does it differ from the replace function? : Sql dba
What is a native sql query?
What is the function that is used to transfer a pl/sql table log to a database table?
What is pl sql architecture?
what is bcp? When is it used?