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

Is primary key a clustered index?

910

---

What is sql basics?

990

---

What is partition by in sql?

1000

---

What is a full join sql?

980

---

Where is sql database stored?

918

---

What is normalization in sql?

962

---

what is the difference between where clause and having clause? : Sql dba

947

---

How many types of primary keys are there?

977

---

How do I view a table in sql?

947

---

How many joins can you have in sql?

880

---

How do I find duplicates in a single column in sql?

951

---

how to concatenate two character strings? : Sql dba

1029

---

What is the execution plan in sql?

972

---

What is primary and foreign key?

1014

---

How do I remove sql plus from windows 10?

1022

---