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 we write dml inside a function in sql server?

469


What are the two virtual tables available at the time of database trigger execution?

609


what is a constraint? : Sql dba

684


Does view store data in sql?

508


How to make a copy values from one column to another in sql?

543






What is the difference between clustered and non-clustered index in sql?

498


How can you create an empty table from an existing table?

560


What are functions in sql?

482


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

488


How can we implement rollback or commit statement in a trigger?

551


What is sql*loader and what is it used for?

550


What is function and procedure?

533


What are the different types of dbmss?

533


Can you have more than one key in a database?

485


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1029