Answer Posted / kirankumar.vangeti

For the same example given in the answer 1

select studentname, subject, count(studentname) as count
from student
group by studentname, subject
having (count(studentname)>1);

above query will give the results like

STUD1 A 2

Define select, insert, create, delete, update, drop keywords

1092

---

How to change sql*plus system settings?

1103

---

How do I trace sql profiler?

1039

---

Does sqlite need a server?

1095

---

What is a record in a database?

1100

---

Define tables and fields in a database

1176

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1051

---

How do I enable sql encryption?

1068

---

what is a foreign key ? : Sql dba

1112

---

How to install oracle sql developer?

1095

---

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

1078

---

What is a full join?

1042

---

Does pl sql work in mysql?

1033

---

What is the unique index?

1107

---

What is difference between stored function and application function?

1288

---