Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / umadevi
SELECT * FROM emp a WHERE 2 = (SELECT COUNT(rowid) FROM
emp b WHERE a.rowid >= b.rowid)
now it will work. instead of :n we have mention row number.
| Is This Answer Correct ? | 26 Yes | 10 No |
Post New Answer View All Answers
How can I delete duplicate rows?
Can ddl statements be used in pl/sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
Explain ddl statements in pl/sql?
What is sql and how does it work?
how to create a test table in your mysql server? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How do I view an execution plan in sql?
What are stored procedures used for?
What is union and union all keyword in sql and what are their differences?
What packages are available to pl/sql developers?
describe mysql connection using mysql binary. : Sql dba
What are the different types of triggers?
What is procedure function?
What is materialized view. What are different methods of refresh?
