Answer Posted / balindra sahani

select max(salary) from table_name where max(salary)not
in(select top(n) from table_name order by salary asc)

where n=nth number salary

Where in ms sql server is ’100’ equal to ‘0’?

1021

---

How can windows applications connect to sql servers via odbc?

1062

---

Explain about protocol layer present in SQL server?

1108

---

Do you know what is sql service broker?

997

---

What are the acid properties?

946

---

How to create database with physical files specified in ms sql server?

956

---

What is data block and how to define data block size?

980

---

Do you know nested transaction?

907

---

what is database replication? : Sql server database administration

988

---

How do I know if localdb is running?

893

---

Explain about analysis services?

982

---

How to define and use table alias names in ms sql server?

1045

---

How column data types are determined in a view?

901

---

What is "scheduled jobs" or "scheduled tasks"?

915

---

Differentiate between a local and a global temporary table?

900

---