one table can have one clustered index and 249 non clustered index.
Type: Posts; User: Amitaqa; Keyword(s):
one table can have one clustered index and 249 non clustered index.
select * from <tablename>emp where salary not in (select distinct top n-1 salary from <tablename>emp order by salary desc)
n=number of highest salary