Answer / haribabuboddapati

select max(sal)*from emp
where sal>select max(sal)*from emp

Answer / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

Answer / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

Describe in brief system database.

0 Answers  

---

When is update_statistics command used?

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What is a cursor in SQL Server 2000 and their types?

8 Answers  

---

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

syntex of insert

7 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---