how to retrive only second row from table?

Answer Posted / priya

select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can a stored procedure call itself or recursive stored procedure? : Sql dba

752


How many types of index are there?

724


How to test for null values?

767


What is sql and db2?

729


Why stored procedure is faster than query?

681






Why commit is not used in triggers?

773


What is user in sql?

762


what are the disadvantages of mysql? : Sql dba

763


what are the differences between binary and varbinary? : Sql dba

720


Does a join table need a primary key?

708


Name three sql operations that perform a sort.

789


How do you rename a table in sql?

736


How many types of normalization are there?

669


Can a composite key be null?

713


what is union, minus and interact commands? : Sql dba

860