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

Is pl sql better than sql?

1042

What is not in sql?

952

What are the limitations of sql express?

1074

What is pls_integer in pl sql?

1108

Explain the components of sql?

1068

What is a pdo connection?

1050

What is clustered and nonclustered index in sql?

944

What is sql exception?

977

Mention what pl/sql package consists of?

1006

What is the use of & in pl sql?

1048

How can we optimize a sql query?

1053

What is the difference between null value, zero, and blank space?

1209

What are the two types of exceptions.

1173

How does an execution block start and end in pl sql?

957

Which one is better subquery or joins?

1068