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

How long will it take to learn pl sql?

932

---

what are the different type of normalization? : Sql dba

1022

---

Mention what plvcmt and plvrb does in pl/sql?

1133

---

What are the different operators available in sql?

997

---

What is sap sql?

971

---

How do I send sql query results to excel?

1058

---

What is cursor explain with example?

974

---

What are all types of user defined functions?

1070

---

What is synchronized subquery?

1158

---

Where is sql database stored?

977

---

What is clustered index in sql?

1046

---

How do I kill a query in postgresql?

1097

---

what is the difference between union and union all? : Sql dba

1013

---

What is rename command in sql?

1021

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1067

---