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.

How long it takes to learn pl sql?

1010

---

How do you optimize a query?

998

---

Can delete statement be rollbacked?

984

---

What are stored procedures in mysql?

1019

---

What is procedure explain with example?

961

---

How can you load multi line records? : aql loader

1076

---

How many types of literals are available in pl sql?

1119

---

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

1005

---

What is full join?

953

---

How do I remove all records from a table?

1074

---

Is progress software supports to ( pl/sql )?

1037

---

What is natural join in sql?

989

---

Why we use joins in sql?

982

---

what are the advantages a stored procedure? : Sql dba

976

---

what is 'mysqlshow'? : Sql dba

1026

---