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

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

1092

---

What is the difference between count 1 and count (*) in a sql query?

1052

---

Can we use delete in merge statement?

1098

---

What is procedure function?

1122

---

How many sql statements are used?

1070

---

Is it possible for a table to have more than one foreign key?

1080

---

What is difference between group by and partition by?

1128

---

What are tables and fields in the database?

1188

---

How do I clear the screen in sql plus?

1086

---

What is a temp table?

1072

---

What is difference between nchar and nvarchar?

1100

---

what is the difference between group by and order by in sql? : Sql dba

1185

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1184

---

When you have to use a default "rollback to" savepoint of plvlog?

1250

---

Is sql considered coding?

1088

---