Answer Posted / ganesh prasad

all are not working properly incase repeat salary
this one is correct

select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)

What is the sql server 2000 version number?

1147

---

what are the new features in SSRS?

145

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1229

---

What is the difference between seek predicate and predicate?

1108

---

Explain cross join or cartesian product in sql?

927

---

What is dbcc?

1179

---

What are the limitations in ssrs on sql server express edition?

195

---

What is the openxml statement in sql server?

1120

---

can you implement data mining in SSRS?

157

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

158

---

What does the update command do?

1173

---

What is difference between count (*) and count column?

948

---

What the class forname () does?

1140

---

What is encryption key?

137

---

Why do we partition data?

1079

---