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

Why we use the openxml clause?

1003

---

How do you migrate data from mssql server to azure?

165

---

How can we use ConnectorJ JDBC Driver with MS SQL?

993

---

How to find related tables in sql server?

927

---

Explain primary key, foreign key and unique key?

986

---

What is 5nf in normalization form?

989

---

Can you force a query to use a specific index?

933

---

What is not null constraint?

1106

---

What is the meaning of sql server?

984

---

Give an example of why you would want to denormalize a database

972

---

What are the properties of sub-query?

1063

---

How to identify current user in ssrs report?

401

---

How many databases instances are there in sql server 2000?

1092

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

904

---

Explain error and transaction handling in sql server?

1005

---