Answer Posted / eldho k scaria

There are two methods:(Suppose table name is EMPLOYEE,
Colomn name is SALARY, and N=6)

SELECT * FROM EMPLOYEE
WHERE SALARY IN
(SELECT TO 1 SALARY (SELECT DISTINCT TOP 6 SALARY FROM
EMPLOYEE ORDER BY SALARY DESC)
A ORDER BY SALARY)
or
SELECT * FROM EMPLOYEE E1
WHERE (6-1)=(SELECT COUNT (DISTINCT (E2.SALARY))
FROM EMPLOYEE E2
WHERE E2.SALARY>E1.SALARY)

How to optimize stored procedure optimization?

896

---

How to provide default values to stored procedure parameters?

1068

---

How retrieve field names from the table in SQL through JAVA code?

1914

---

Explain indexed views?

988

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

988

---

What are trace flags?

1037

---

whats the maximum size of view state??

2193

---

what is sql server? : Sql server database administration

993

---

Explain triggers in sql?

957

---

Write a SQL query to make a column as unique?

1044

---

How you can get a list of all the table constraints in a database?

957

---

How to run queries with sql server management studio express?

1095

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1849

---

What is explicit mode in sql server?

1066

---

Explain what is raid and what are different types of raid levels?

1027

---