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);

Relational calculus is what type of language?

978

---

What is difference between rownum and row_number?

911

---

What is a covered index?

893

---

How to insert a new row into a table with "insert into" statements in ms sql server?

915

---

How can you append an identity column to a temporary table?

877

---

Explain the relational database management system (rdbms)?

1021

---

What is dbcc command in sql server?

1021

---

What stored by the msdb? : sql server database administration

954

---

How can we delete Duplicate row in table?

1000

---

What are the approximate numeric data types?

877

---

plss anybody specify tha constrian management system in dbms

2082

---

Why is sql server log file full?

979

---

What are the transaction properties?

964

---

How to backup SQL Server Reporting Services ?

137

---

Explain data warehousing in sql server?

991

---