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
what is the use of friend function? : Sql dba
What does count (*) mean?
How do we use distinct statement? What is its use?
What is dense_rank?
What is procedure explain with example?
Is pl sql different from sql?
explain advantages of myisam over innodb? : Sql dba
What are the qualities of 2nf?
What are the different operators available in sql?
How does a covering index work?
What is a recursive join sql?
what is a composite key ? : Sql dba
How much does sqlite cost?
What is sql in oracle?
what are different types of collation sensitivity? : Sql dba
