Answer Posted / vinay upadhyay

These are tested queries to find Nth highest salary

Select distinct(sal) From employee emp Where n =
( Select Count(Distinct y.sal) From employee y Where y.sal
>=emp.sal)

OR

select distinct(salary) from employee order by salary desc
limit n-1,1

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1090

---

What is sql or structured query language?

1159

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6902

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1056

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1923

---

How can a user-defined datatype be created?

993

---

What is implicit mode in sql server?

1111

---

Explain about link server in sql server?

1064

---

Do you know what are the reporting services components?

982

---

What is the Difference Between Primary and Foreign Key?

1017

---

Mention the differences between sql server and mysql.

1026

---

How to convert a unicode strings to non-unicode strings?

1109

---

How to test odbc dsn connection settings?

1043

---

Difference between aggregate functions of sql?

1110

---

What are the three different part of rdl file explain them?

269

---