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

What is the difference between between and in condition operators?

986

What is normalisation in sql?

1041

how do you know the version of your mysql server? : Sql dba

987

what is sql in mysql? : Sql dba

1176

Does sql view stored data?

938

What are the qualities of 2nf?

1023

What are the different types of sql commands?

1109

What is the difference between functions, procedures, and packages in pl/sql?

1025

Which command is used to delete a trigger?

1308

What is string join?

963

What does (+) mean in sql joins?

1046

how do you login to mysql using unix shell? : Sql dba

1068

What is dynamic query?

957

how to calculate the difference between two dates? : Sql dba

1043

Write a sql select query that only returns each name only once from a table?

995