Answer Posted / sanwar hudda

n th Highest salary

select salary from test t1 where n-1=(select COUNT (*) from
test

where salary > t1.salary )

What are a scheduled jobs or what is a scheduled tasks?

947

---

Can the query output be sorted by multiple columns in ms sql server?

1032

---

What is attribute hierarchy? : sql server analysis services, ssas

1067

---

Explain the concepts and capabilities of sql server?

1014

---

What is table valued function and scalar valued functions?

1166

---

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

1565

---

How to attach adventureworkslt physical files to the server?

1161

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1190

---

Tell me what is a linked server?

1087

---

What is a filestream?

1049

---

what is normalization? : Sql server database administration

1163

---

What is a trigger and its types?

1043

---

What is row-level compre?

1051

---

How can a database be repaired?

1034

---

Write a query to find 5th highest amount paid from the customer table.

994

---