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 offset in sql query?
What is percent sign in sql?
What are schema-level triggers?
what does it mean to have quoted_identifier on? : Sql dba
What is an ndf file?
What are the two types of exceptions.
how to use in conditions? : Sql dba
How many types of cursors are available in pl/sql?
Why do we use sql constraints?
What is the most restrictive isolation level? : Transact sql
What is the usage of when clause in trigger?
What is the use of <> sql?
Can instead of triggers be used to fire once for each statement on a view?
What is sql character function?
what is difference between delete and truncate commands? : Sql dba
