Answer Posted / sagar
SELECT * FROM tab a
WHERE :n = (SELECT COUNT(rowid)
FROM tab b
WHERE a.rowid >= b.rowid);
| Is This Answer Correct ? | 14 Yes | 33 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
Can we use ddl commands in pl sql?
What does := mean in pl sql?
How does stored procedure reduce network traffic?
What is query optimization in sql?
Explain what is an index?
what is the difference between myisam static and myisam dynamic? : Sql dba
Is sql better than excel?
what are different types of keys in sql?
What is the purpose of design view?
Can a select statement fire a trigger?
What is pls integer?
How can triggers be used for the table auditing?
Explain ttitle and btitle.
what are wild cards used in database for pattern matching ? : Sql dba
