Answer Posted / sri

For example,u have a table called student like below.

STUD-NAME SUBJECT
--------- ------
STUD1 A
STUD2 B
STUD2 A
STUD1 A

in this structure 1 row is duplicated in 4 th. so we can
fetch the student name using the below qry.

SELECT stud-name FROM STUDENT
GROUP BY stud-name,subject
HAVING COUNT > 1.

What is the difference between row level and statement level trigger?

957

---

What is the difference between the conventional and direct path loader? : aql loader

1110

---

What does (+) mean in sql joins?

1010

---

How can you view the errors encountered in a trigger?

915

---

What is the difference between sum and count in sql?

936

---

what are the types of join and explain each? : Sql dba

989

---

What is pl sql collection?

919

---

What is lookup table in sql?

979

---

What is an index in sql with example?

918

---

What is the difference between unique and primary key constraints?

1007

---

What's the difference between inner join and left join?

946

---

Explain table and field in sql?

1014

---

What is an inconsistent dependency?

978

---

How do I remove sql developer from windows 10?

1012

---

what is a database lock ? : Sql dba

1092

---