Interested to Buy Any Domain ? << Click Here >> for more details...
sql query to get zero records from a table having n no of
records
- 8 Answers
- 26187 Views
- CTS, I also Faced
- E-Mail Answers
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
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is cross join? : Sql dba
Which data type is a composite type?
What is the use of sql trace?
How exception is different from error?
How do I create an index in word?
How to run sql*plus commands in sql developer?
Why primary key is required?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
what is data manipulation language? : Sql dba
How to call shell script from pl sql procedure?
Enlist the data types that can be used in pl/sql?
Why do we need a foreign key?
Differentiate between syntax and runtime errors.
