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

Can we use where clause with group by?

855

---

Which is the main third-party tool used in sql server?

882

---

What are different types of raid configurations? : SQL Server Architecture

1003

---

What are the new data types are introduced in sql 2000?

859

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

980

---

What are the properties of the transaction?

968

---

How to Insert multiple rows with a single insert statement?

1000

---

Explain transaction server isolation?

979

---

define and explain the differences between clustered and non-clustered indexes.

1118

---

How to drop an existing table with "drop table" statements in ms sql server?

1034

---

What is a field in a table?

983

---

Mention the uses of stored procedures.

927

---

What is normalization 1nf 2nf 3nf?

1003

---

What is difference between primary key and foreign key?

834

---

Can primary key be a foreign key?

997

---