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)

How to create function without parameter in sql server?

992

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

916

---

difference between Clustered index and non clustered index ?

936

---

How sql server enhances scalability of the database system?

1114

---

Do you know what is normalization of database? What are its benefits?

1028

---

What do you understand by recursive stored procedures?

940

---

What is ms sql server triggers?

946

---

Explain what is the main purpose of having conversation group?

882

---

What are the 3 types of schema?

1042

---

Relational calculus is what type of language?

978

---

What is difference between delete & truncate commands?

1025

---

What is difference between materialized view and view?

879

---

Do you know sql server 2008 backup compression?

922

---

How to receive output values from stored procedures?

1057

---

What is meant by datasource?

874

---