Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

What is the simplest SQL query to find the second largest integer value in a specific column?

There are maybe duplicate values in the column.

1 Answer

0 votes
by (40.4k points)

Try using the below code:

SELECT MAX( col )

  FROM table

 WHERE col < ( SELECT MAX( col )

                 FROM table )

Related questions

0 votes
1 answer
asked Apr 20, 2020 in SQL by Sudhir_1997 (55.5k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...