Answer Posted / kiran k s

select distinct(salary) from table t1
where 4=(select count(distinct(salary))from table t2
where t2.salary >= t1.salary);

How to insert new line characters into strings?

994

---

Explain syntax for dropping triggers?

934

---

What is the process of normalising?

1000

---

How to get the query of a table in sql server?

900

---

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

1064

---

Is candidate a key?

955

---

How many types of subqueries are there in sql server?

992

---

What is the order by used for?

1024

---

What is exporting utility?

1028

---

Why the trigger fires multiple times in single login?

1213

---

Where actually sql azure database is hosted?

163

---

How can change procedure in sql server?

1071

---

How to rename databases in ms sql server?

1206

---

What are the pre-defined functions in the sql server?

1116

---

How to insert multiple rows with one insert statement in ms sql server?

1131

---