TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Bineesh Viswanath
NA
1k
775.4k
Display Second highest value in a Table in SQL Server
Jun 6 2013 11:26 PM
Sir, I have a table name tbl_Employee
the contents are:-
emp.ID Name Salary
05 John 5000
08 Rose 4000
10 Mathew 6000
I want to display emp.Id ,Name and Salary of employee whom salary is second highest in this table
please send me the SQL Query
Reply
Answers (
4
)
lastName in ASC and Salary in Desc Order in a SQL Table
Find Details of Employee in SQL