Answer Posted / lova raju allumalla

instead of deptno the result will give u in department name

select sum(sal),dname from emp e,dept d where
e.deptno=d.deptno group by dname
/

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7348

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4025

---

Are subqueries faster than joins?

1021

---

define data blocks ? : Sql dba

996

---

What is sql engine in oracle?

989

---

What are the benefits of pl sql?

1121

---

What is primary and foreign key?

1064

---

Write a sql query to convert all character to uppercase after hypen.

1438

---

Mention what does plv msg allows you to do?

1122

---

What are sql objects?

1079

---

What is a unique key and primary key and foreign key?

969

---

Is primary key always clustered index?

1023

---

How to change sql*plus system settings?

1054

---

What is the usage of when clause in trigger?

1057

---