Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
How to get five max with column name?
Amit Arya
Feb 7 2014 1:17 PM
997
Reply
I want maximum number of votes from these 3 columns(cong, bjp and aap) with associate column name
my table is :
Cong
BJP
AAP
Winner
Win By
18515
72283
23757
BJP
48526
24730
29373
36863
AAP
7490
expected result:
maxvote
Party Name
72283
BJP
36863
AAP
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Connect SQL Server to VS
Inner Join Query incorrect result