Ex Code: Lowest case :
select top 1 column as 'salary' from (select distinct top 4 column from Table order by ID asc) a order by ID desc
Highest Case:
select top 1 column as 'salary' from (select distinct top 4 column from Table order by ID desc) a order by ID asc
select top 1 column as 'salary' from (select distinct top 4 column from Table order by ID asc) a order by ID desc
Highest Case:
select top 1 column as 'salary' from (select distinct top 4 column from Table order by ID desc) a order by ID asc
No comments:
Post a Comment