Answer Posted / abhishek singh

SELECT TOP 1 salary
FROM dbo.emp
WHERE (salary IN
(SELECT DISTINCT TOP n salary
FROM dbo.emp
ORDER BY salary DESC))
ORDER BY salary

List down some advantages of sql stored procedure?

906

---

Is oracle faster than sql server?

891

---

How to execute a stored procedure in ms sql server?

1071

---

What is 3nf normalization?

928

---

What is normalization of database? What are its benefits?

963

---

Where can you add custom error messages to sql server?

1055

---

What is sql server management studio? : sql server management studio

1016

---

what type of index will get created after executing the above statement? : Sql server database administration

922

---

How to defragment indexes with alter index ... Reorganize?

1028

---

Does sql server 2016 have ssms?

913

---

How do use Having,Group by,Group function in SQL?

1693

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

---

What are different types of join?

1237

---

What is subquery in sql?

989

---

Can I delete event logs?

877

---