Answer Posted / ramana

Table Like this

Create Table Employee(Name varchar(20),Location
varchar(20),Salary int)

Query Like this

Select top 1 * from employee where Name not in(select top 1
Name from Employee)

it will display second record....

What is the recursive stored procedure in sql server?

1016

---

Are resultset updatable?

945

---

Why main is user defined function?

1003

---

What are filegroups in sql server?

1054

---

What is amo? : sql server analysis services, ssas

1085

---

Can you get second highest salary from the table?

957

---

Can a database be shrunk to 0 bytes, if not, why?

1090

---

How can you fetch alternate records from a table?

953

---

Explain what are magic tables in sql server?

987

---

Explain error handling in ssis?

1011

---

What is a select query statement in ms sql server?

1065

---

What number sorts of privileges are accessible in sql?

1026

---

Determine when to use stored procedure to complete sql server tasks?

1045

---

What is auditing in sql server?

918

---

What is extended stored procedures?

952

---