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 union and union all keyword in sql and what are their differences?
What is delimiter in pl sql?
What does := mean in pl sql?
How do you go back in sql?
What is snowflake sql?
What is scalar function in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How to test for null values?
What is meant by truncate in sql?
what is cursor. write example of it. What are the attributes of cursor.
Which is better varchar or nvarchar?
Which command is used to call a stored procedure?
How do you determine the current isolation level? : Transact sql
How to raise user-defined exception with custom sqlerrm ?
What are the various levels of constraints?
