SQL Recipes a FREE cookbook of SQL queries and examples - View Single Post - How to find second highest value of a column in a table? | SQL?

Thread: How to find second highest value of a column in a table? | SQL?

View Single Post

#10 (permalink)

Old

07-24-2007, 11:07 AM

Unregistered

Posts: n/a

Thumbs up

ANY answer. Re: How to find second highest value of a column in a table? | SQL?

This is sekhar
[sql]select max(sal) from emp where sal< (select max(sal) from emp)[/sql]

Reply With Quote