Answer Posted / ashish kumar

To find nth maximum salry

Select salary from tbl_name a where
n-1=(Select count(distinct(count(*))) from tbl_name b
where b.salary>a.salary)

How use inner join in sql server?

1054

---

How do you use a subquery to find records that exist in one table and do not exist in another?

991

---

How many primary keys are possible in a table?

872

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

959

---

What is data set in report?

121

---

What are the differences between stored procedure and view in sql server?

1158

---

What are the benefits of filtered indexes?

977

---

How to create an inline table-valued function?

907

---

Which are the two editions in which SQL Azure database available?

117

---

Explain syntax for viewing trigger?

884

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

908

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2164

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1001

---

How to create a local temporary stored procedure?

946

---

What happens when unicode strings concatenate with non-unicode strings?

1000

---