Answer Posted / akki julak

FOR EXAMPLE WE HAD TAKE EMP TABLE AND ENAME,EMPNO AS COLUMNS

SELECT EMPNO,ENAME
FROM EMP
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME);


by
AKKI JULAKANTI

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

4026

---

Is drop table faster than truncate?

992

---

How do I order columns in sql?

1012

---

What is bitemporal narrowing?

1312

---

What is microsoft t sql?

950

---

Can a composite key be null?

982

---

What is loop in pl sql?

1040

---

which types of join is used in sql widely? : Sql dba

983

---

How do you drop a trigger?

996

---

What are the types of operators available in sql?

1067

---

What are the disadvantages of file system?

1268

---

How to disable a trigger name update_salary?

1267

---

Which table is left in left join?

1018

---

How to write html code in pl sql?

1119

---

Can %notfound return null after a fetch?

1062

---