Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ayan
SELECT * FROM employees a
WHERE 2 = (SELECT COUNT(rowid)
FROM employees b
WHERE a.rowid >= b.rowid);
this will select the 2nd row.. if we write instead of 2 it
will select 8th row.... login to hr/hr schema and run the
code. it will work fine..
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Can a foreign key have a different name?
Is sqlexception checked or unchecked?
What is sql partition?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is the difference between truncate and drop statements?
Is sqlite thread safe?
What is gpt format?
Is sql developer case sensitive?
What are the possible values for the boolean data field?
How to write html code in pl sql?
What is character functions?
Explain the order of sql statement execution?
what is the difference between a having clause and a where clause? : Sql dba
What are the different types of a subquery?
How do I view a view in sql?
