Answer Posted / kavitha.r

Sorry. This one is correct


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

How to use clusters?

965

---

How to add a new dsn with the odbc driver for sql server?

1067

---

Difference between report and query parameter.

1106

---

How does a profiler work?

940

---

what are user defined datatypes? : Sql server database administration

975

---

What is the difference between resultset and resultsetmetadata?

981

---

How do I delete a sql server database?

1050

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1117

---

What is correlated subquery in sql server?

1078

---

What is temporal data type?

925

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

955

---

Does view occupy space?

951

---

How much memory that we are using in Logshipping Concept?

1802

---

How connect excel to sql server?

1003

---

What the different topologies in which replication can be configured?

1098

---