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)

Is sql server a database?

958

---

List the different types of joins?

965

---

What are the differences between having and where clause.

954

---

Define indexes?

1027

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

962

---

What is difference between stored procedure and user defined function?

1079

---

Is candidate a key?

928

---

What is a view and what are its advantages?

1094

---

If user is owning any SQL Objects, can we drop that user

2048

---

What are relationships and mention different types of relationships in the dbms

945

---

what is isolation level at dead lock?

2131

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2910

---

What is store procedure? How do they work?

982

---

what is an extended stored procedure? : Sql server database administration

1032

---

How to create indexed view?

1026

---