Answer Posted / jiten

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

what is bit datatype? : Sql server database administration

866

---

What is an index in a database?

927

---

Explain what are the restrictions while creating batches in sql server?

1023

---

What are information schema views?

924

---

How to add code to the existing article (using improve article)?

1050

---

Can sql servers link to other servers like oracle?

795

---

What is a non clustered primary key?

877

---

How you can get the list of largest tables in a database?

945

---

What does indexation mean?

917

---

What is pivot and unpivot?

978

---

How to use column default values in insert statements in ms sql server?

975

---

What will be query used to get the list of triggers in a database?

955

---

What are page splits? : SQL Server Architecture

938

---

How much does sql server 2016 cost?

989

---

Can we use having clause without group by?

931

---