Answer Posted / ankur bakliwal

I think this should work -


select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

968

---

Can we use having clause without group by?

980

---

What is surrogate key? : sql server analysis services, ssas

1109

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1048

---

Differentiate sql server reporting services vs. Crystal reports?

201

---

What are different replication agents and what's their purpose? : sql server replication

1022

---

Explain raiserror in sql server?

1029

---

What do you understand by recursive stored procedure?

930

---

How to round a numeric value to a specific precision?

1075

---

Why people hate cursor?

1148

---

How you can get the list of largest tables in a database?

1016

---

What is cursors? And what are the different types of cursor?

1145

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147

---

Do you know what are the ways available in sql server to execute sql statements?

1032

---

What is subquery in sql?

1070

---