Answer Posted / jayaraman b

select min(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 2nd largest Salaried employee

select max(emp_no) from
(select top 2 * from emp order by emp_no desc)A
--This will give you the 1st largest Salaried employee

How do I find the default sql server instance?

906

---

What are the types of indexes?

1033

---

Can you please differentiate between a primary key and a unique key?

954

---

What is the difference between a function and a stored procedure?

1007

---

How to replace the Query Result 'Null Value' with a text ?

974

---

When would you use it?

945

---

State the difference between local and global temporary tables?

1051

---

What is pivot and unpivot?

978

---

Can sql server be linked with other servers like oracle?

905

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

966

---

Explain what is raid and what are different types of raid levels?

954

---

Mention the different authentication modes in sql server.

966

---

Explain index in sql server?

966

---

Explain the properties of a relational table?

980

---

Explain about sql server login?

1029

---