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 difference between openrowset and openquery?

1163

---

How do I create a partition table in sql server?

1185

---

What are the purposes and advantages stored procedure?

1020

---

Why main is user defined function?

1052

---

What stored by the msdb? : sql server database administration

1053

---

Can an automatic recovery be initiated by a user?

1069

---

How do I create a stored procedure in dbml?

1084

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2081

---

What is subquery explain with example?

1124

---

How to find the second highest salary of an employee?

1224

---

Can you insert NULL in unique column?

1213

---

What is a field in a table?

1075

---

explain different levels of normalization? : Sql server database administration

1051

---

How would we use distinct statement? What is its use?

1125

---

How to query multiple tables jointly?

1044

---