| Author: saroop 27 Aug 2008 | Member Level: Silver | Rating:  Points: 0 |
select top 3 sal from "table" order by sal asc
|
| Author: kalaimanichozhan 27 Aug 2008 | Member Level: Gold | Rating: Points: 0 |
select top 3 sal from salary order by sal
|
| Author: palla 28 Aug 2008 | Member Level: Silver | Rating: Points: 3 |
hi
we can use this select if we doesnt use top keyword.
select e1.sal
from emp e1 where 3>(select count(distinct(e2.sal))
from emp e2 where e2.sal>e1.sal)
order by e1.sal
|