Answer Posted / jiten

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

How to update multiple rows with one update statement in ms sql server?

1263

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2077

---

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

1071

---

How to set a database state to offline in ms sql server?

1107

---

What is the full form of ddl?

973

---

What is difference between drop truncate and delete?

1157

---

What are the underflow and overflow behaviors on float literals?

1168

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

995

---

how you can get the list of largest tables in a database? : Sql server administration

1105

---

What are triggers in ms sql server?

1230

---

What happens on checkpoint?

1073

---

Write a program using SQL queries to find a unique entry in a table.

1049

---

what is the difference between count(*) and count(1) ?

1127

---

Does table partitioning improve performance?

1015

---