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

Does access use sql?

964

What is %s in sql?

970

How do temporal tables work?

907

What is sql prepared statement?

936

What is the difference between microsoft access and sql server?

986

Enlist the advantages of sql.

935

Can we connect to postgresql using sql developer?

932

How is a PL/SQL code compiled?

1167

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1110

Explain the difference in execution of triggers and stored procedures?

965

What are the dml statements?

1094

how can we know the number of days between two given dates using mysql? : Sql dba

990

How do you clear the screen in sql?

1009

What program will open a mdb file?

909

Why we use join in sql?

911