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

What are the different index configurations a table can have?

960

---

What are relationships and mention different types of relationships in the dbms

961

---

What is shrink log file?

897

---

What is ms sql server service broker?

991

---

What is change tracking in sql server?

1025

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1017

---

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

953

---

What is triggers in ms sql server?

1118

---

Can coalesce return null?

1012

---

How will you monitor replication latency in transactional replication? : sql server replication

1142

---

What do you mean by acid?

990

---

How do I start sql server agent automatically?

968

---

Can a database be shrunk with users active?

1133

---

Explain the purpose of indexes?

976

---

How to identify current user in ssrs report?

403

---