how to retrive only second row from table?

Answer Posted / sandhya rani

This is perfect answer...
and do not misguide the ppl by simply writing wrong answer.
until and unless u r perfect..pls do not share your answer


select * from emp where rownum<=2
minus
select * from emp where rownum<2

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger and stored procedure in sql?

560


What do you mean by stored procedures? How do we use it?

529


how many tables will create when we create table, what are they? : Sql dba

549


what is commit? : Sql dba

619


how to increment dates by 1 in mysql? : Sql dba

543






How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

586


How to add, remove, modify users using sql?

563


What is pivot query?

598


Differentiate between % rowtype and type record.

735


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

622


Explain autonomous transaction.

640


How do I view a view in sql?

512


what is a record in a database ? : Sql dba

570


Do we need to create index on primary key?

471


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

567