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 cursor. write example of it. What are the attributes of cursor.
What is difference between table and view?
how to enter binary numbers in sql statements? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the difference between subquery and correlated query?
How do we accept inputs from user during runtime?
How long will it take to learn pl sql?
is mysql query is case sensitive? : Sql dba
Does inner join return duplicate rows?
What jobs use sql?
What is number function in sql?
where are cookies actually stored on the hard disk? : Sql dba
What is data profiling in sql?
What is trigger price?
How do you use a while loop in pl sql?
