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....

How can I get data from a database on another server?

997

---

How will you find out if there are expensive SQL statements running or not?

1015

---

Explain table valued parameters in sql server? Why tvp used?

1020

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1993

---

What is BCNF? How is it better than 2NF & 3NF?

1018

---

What does it mean if @@cursor_row returns a negative number?

992

---

Does a server store data?

928

---

How many clustered indexes there can be on table ?

1039

---

What are the lambda triggers?

905

---

Explain log shipping?

1021

---

Can we update data in a view?

1034

---

How to execute a sql statement using odbc_exec()?

1144

---

What is difference between createstatement and preparedstatement?

1091

---

What are the events recorded in a transaction log?

1000

---

What is spatial and temporal data?

1007

---