select top 1 emp_salary from (select top 6 emp_salary from tblemployee order by emp_salary desc) a order by emp_salary asc
Type: Posts; User: Priyanka Sinha; Keyword(s):
Re: How to get 6th heghest salary?
select top 1 emp_salary from (select top 6 emp_salary from tblemployee order by emp_salary desc) a order by emp_salary asc
Re: what is a trigger?
Triggers allow us to execute a batch of sql code when either an insert, update or delete command is executed against a specific table. Triggers fires automatically whereever there is any insert or...