Answer Posted / udayalakshmij

select emp_name,max(salary) from emp except(select max(salary) from emp);

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

999

---

What is sql and explain its components?

1058

---

Can you upgrade sql express to full sql?

1060

---

What is a data manipulation language?

1020

---

What are all different types of collation sensitivity?

1029

---

Is postgresql a server?

1046

---

Which join is default?

950

---

What is error ora-01000: maximum open cursors exceeded

1141

---

Which software is used for pl sql programming?

983

---

Define union, minus, union all, intersect ?

1000

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

966

---

Can you selectively load only those records that you need? : aql loader

1045

---

What is bind reference and how can it be created?

1016

---

How long it takes to learn pl sql?

1010

---

Is left join same as inner join?

1121

---