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
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is the difference between count 1 and count (*) in a sql query?
What are the different type of joins in sql?
What is the non-clustered index in sql?
What is bitemporal narrowing?
Why do we use joins in sql?
What is tuple in sql?
What are all the different types of indexes?
What does the file extension accdb stand for?
Does truncate need commit?
What are local and global variables and their differences?
What are variables in pl sql?
Write a query to display the current date in sql?
What is server name sql?
What is example of database?
