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 percent sign in sql?
What is meant by truncate in sql?
What is sql exception?
Is primary key clustered index?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
What is coalesce in sql?
How to install oracle sql developer?
in materialized view the structure will create immediately or not?
what is the difference between where clause and having clause? : Sql dba
What are sql procedures?
How do you take the union of two tables in sql?
What is execute immediate?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)