Answer Posted / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

Is port 1433 secure?

931

---

What is difference between table aliases and column aliases? Do they affect performance?

913

---

what is checksum in sql server.........???

1623

---

Can you please explain the difference between function and stored procedure?

961

---

What is update_statistics command?

1022

---

What is SubQuery in SQL Server 2008

966

---

Describe how to use linked server?

937

---

Can we add an identity column to decimal datatype?

944

---

Define normalisation?

1062

---

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

943

---

How to assign null values to variables or columns?

915

---

What are the extra roles available in msdb? : sql server security

1078

---

What is join query?

840

---

Can foreign key be deleted?

873

---

Can we join two tables without primary key?

982

---