Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is delimiter in pl sql?
What is primary key and foreign key with example?
What is an index in sql with example?
How do I turn a list into a table?
Explain locks? : Transact sql
how to drop an existing index in mysql? : Sql dba
What is a sql driver?
What is vector point function?
How to convert comma separated string to array in pl/sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the use of <> sql?
Mention what pl/sql package consists of?
How do I create a sql database?
What is the difference between alter trigger and drop trigger statements?
