Answer Posted / ganesh prasad

all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722

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

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

---

How to connect to a sql server using odbc_connect()?

1155

---

Is port 1433 secure?

997

---

Differentiate between ms sql server reporting services vs crystal reports?

905

---

When to use null data driven subscription?

206

---

What is user defined stored procedures?

946

---

What are the types of subquery?

1042

---

Explain what is cte (common table expression)?

1131

---

What is a deadlock and what is a live lock?

1003

---

can an automatic recovery be initiated by a user? : Sql server administration

956

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8156

---

Is sql server difficult to learn?

923

---

What is a trace frag?

1085

---

What do you mean by SQL injection attack?

1066

---

Find nth lowest salary or get nth lowest salary?

1029

---