skip to main
|
skip to sidebar
SQL SERVER-2005
Saturday, October 24, 2009
Get 3 Max Value
Select salary from (select salary from emp)a,(select salary from emp)b
where a.salary>= b.salary
Group by (b.salary)
having count(b.salary) = 3
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
▼
2009
(4)
▼
October
(2)
Some Good Questions
Get 3 Max Value
►
September
(1)
►
May
(1)
About Me
microtopic
View my complete profile
No comments:
Post a Comment