Answer Posted / sabin v jacob

SELECT Min(Sal) FROM (SELECT TOP 2 Sal FROM emp ORDER BY
Sal desc) as Temp

or

SELECT Min(Sal) FROM emp WHERE Sal IN(SELECT TOP 2 Sal FROM
emp ORDER BY Sal DESC)

Explain the difference between control flow and data flow?

933

---

How to apply filtering criteria at group level with the having clause in ms sql server?

947

---

How do I view a trc file?

900

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1028

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

970

---

How to concatenate two strings in SQL Server.

1082

---

What are the recovery models for a database?

1058

---

How global temporary tables are represented and its scope?

907

---

Can one drop a column from a table?

968

---

What stored by the master?

904

---

Write down the syntax and an example for create, rename and delete index?

925

---

What is the difference between primary key and unique constraints?

904

---

What Are the Main Features of SQL Azure?

115

---

How to see the event list of an existing trigger using sys.trigger_events?

1026

---

What is the difference between online clustering and Offline clustering?

2357

---