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
define join and explain different type of joins? : Sql dba
Why join is faster than subquery?
What is error ora-12154: tns:could not resolve the connect identifier specified?
What is a native sql query?
what is myisam? : Sql dba
What are the advantages of pl sql over sql?
Is inner join same as self join?
what is an extent ? : Sql dba
what is collation? : Sql dba
Which is faster truncate or drop?
what is the use of friend function? : Sql dba
Is there any restriction on the use of union in embedded sql?
What is pl sql code?
How to rename a table?
What view means?
