Answer Posted / ramakrishna

select e1.* from emp e1 where n=(select
count(distinct(e2.sal)) from emp e2 where e1.sal<=e2.sal);

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

849

---

When should you use an instead of trigger?

935

---

Can we use where clause with group by?

874

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

937

---

How to change server name in sql server?

1124

---

Explain the usage of floor function in sql server.

928

---

Explain how would you store your query in an SSRS report or a Database server?

118

---

What should be the fill factor for indexes created on tables? : sql server database administration

1108

---

how would you store your query in an SSRS report or a Database server?

158

---

What are the differences between local and global temporary tables?

1034

---

Can two tables share a primary key?

970

---

What does it mean to be in union?

891

---

What is the main purpose of having conversation group?

860

---

Name few of the dcl commands in sql?

975

---

Give me a SQL Query to find out the second largest company?

1140

---