Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.73K
1 Posted Topic
You can select the second highest value using a subquery: [CODE]select top 1 * from (select top 2 * from employee order by salary desc) as tmp order by tmp.salary[/CODE] -------------------- [URL="http://www.ahewd.com"]http://www.ahewd.com[/URL]
The End.