select * from emp where empno < (select max(empno) from emp) and rown

how to retrive only second row from table?

Question Posted / priya

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

Please Help Members By Posting Answers For Below Questions

how would concatenate strings in mysql? : Sql dba

1090

How do you optimize a stored procedure query?

996

What is error ora-01000: maximum open cursors exceeded

1141

What are all types of user defined functions?

1073

What is on delete restrict?

1000

What is sqlca in powerbuilder?

1003

What is difference between primary and secondary key?

1023

what is view? : Sql dba

953

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2217

What is left join example?

945

What is normalization in a database?

1152

Can we join tables without foreign key?

958

What are the types of subqueries?

1053

How to call shell script from pl sql procedure?

1276

How can you fetch common records from two tables?

1059