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 clause?
What is java sql drivermanager?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is keyword pl sql?
what is the functionality of the function htmlentities? : Sql dba
What does bitemporal mean?
How is pl sql different from sql?
What is file based approach?
what is data control language? : Sql dba
Can you rollback after commit?
Explain the purpose of %type and %rowtype data types with the example?
What are all the different normalization?
Can we join same table in sql?
What is sqlservr exe?
Which sql statement is used to delete data from a database?
