Answer Posted / manshul

select * from employee e, (select salary, rownum rn from
(select distinct salary from employee order by salary desc))
T where T.sal= e.sal and T.rn = 4

What is best institute to Learn DotNET And SQL in chennai?

2116

---

How to concatenate two character strings together?

1058

---

What is similarity and difference between truncate and delete in sql?

1033

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

864

---

What are audit control procedures?

942

---

What is a data source or ds? : sql server analysis services, ssas

952

---

Differentiate between mongodb vs. Sql server?

1035

---

What is the beast way to write CTE in SQL Server ?

986

---

Is port 1433 secure?

932

---

What is ms sql server reporting services?

996

---

How to invoke a trigger on demand?

1029

---

How many instances per computer are there in sql server 2000?

1010

---

Which tcp/ip port does the sql server run on? How can it be changed?

996

---

what is datawarehouse?

1057

---

How to connect to SQL Azure Database by using sqlcmd?

136

---