Answer Posted / vikas kant

---To get 2nd highest salary----

select Top 1 salary from Emp where marks in(select top 2
salary from Emp order by salary desc)

---To get 3rd highest salary----

select Top 1 salary from Emp where marks in(select top 3
salary from Emp order by salary desc)



Regards Vikas Kant

How to connect to SQL Azure Database by using sqlcmd?

136

---

Explain the properties of the relational tables?

936

---

How to edit table in sql server 2017?

878

---

How to create a large table with random data for index testing in ms sql server?

977

---

How to manipulate data from one table to another table ?

905

---

Can sql servers link to other servers?

1020

---

How to create a view with data from multiple tables?

962

---

What are cursors and when they are useful?

1009

---

In which files does sql server actually store data?

849

---

Why is the need for data conversion transformations?

976

---

Does order by actually change the order of the data in the tables or does it just change the output?

1078

---

What are the types of lock supported by ?

995

---

How to specify the collation for a character data type in ms sql server?

962

---

When cursors are useful?

1033

---

What are differences in between sql server 2012 and sql server 2016?

974

---