Answer Posted / dewashish kumar pal

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


note:- t = tablename

Is the log file is a part of file group?

1041

---

What are a database and a data warehouse?

1024

---

What are the purposes and advantages stored procedure?

961

---

What program is used to store the data source file?

965

---

What is ms sql server triggers?

1018

---

What are scalar functions?

1002

---

What stored procedure can you use to display the current processes?

896

---

How you can change a cross join into an inner join?

976

---

What are sql server functions?

987

---

What is data source document?

1044

---

Does sql server use t sql?

1027

---

Does transparent data encryption provide encryption when transmitting data across the network?

1051

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

995

---

Is foreign key unique?

1004

---

What command is used to rename the database?

1015

---