Answer Posted / dewashish kumar pal

select salary from tablename t where (n-1)= (select count(*) from tablename where salary > t.salary);


note:- t = tablename

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1042

---

What are the 7 disadvantages to a manual system?

909

---

What is the difference RDBMS and Graph Database?

1006

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

918

---

What is 2nf normalization?

970

---

What are types of scd? : sql server analysis services, ssas

975

---

What is filestream?

945

---

Explain alternate key, candidate key and composite key in sql server?

862

---

How to find table changes in sql server?

1053

---

What are the differences between having and where clause.

924

---

Explain triggers?

945

---

How do you make a trace?

958

---

Explain error handling in ssis?

966

---

How to add more data to the testing table in ms sql server?

1002

---

between cast and convert which function would you prefer and why?

917

---