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 are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

application server is slow what may be the problem

0 Answers   Microsoft,

---

How to create a view using data from another view?

0 Answers  

---

Explain what is lock escalation?

0 Answers  

---

Can we use where and having clause together?

0 Answers  

---

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

What types of replication are supported in sql server?

0 Answers  

---

What is an indexed view?

0 Answers  

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

What is normalization? What number of normalization shapes are there?

0 Answers  

---