how to retrive only second row from table?

Answer Posted / rajeev thakur

(select * from emp where rownum<3) minus (select * from emp
where rownum<2);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of sql commands?

520


how to use like conditions? : Sql dba

544


What is a schema sql?

505


What is the difference between a subquery and a join?

505


How do you copy a table in sql?

539






how to fetch common records from two tables? : Sql dba

601


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

503


Can we have two clustered index on a table?

539


How do I run a script in sql developer?

472


what are date and time data types in mysql? : Sql dba

471


How can we link a sql database to an existing android app?

531


What is mutating trigger?

546


Describe different types of general function used in sql?

505


Define commit?

529


Should I use mbr or gpt?

514