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
How does cross join work?
How to add new employee details in an employee_details table with the following details
What are the various restrictions imposed on view in terms of dml?
What is sql keyword?
How do I write a cron which will run a sql query and mail the results to agroup?
Explain clause in sql?
What are sql indexes?
Is sql microsoft?
How do you know if a relationship is 2nf?
What is difference between group by and partition by?
What are the different type of joins in sql?
What are schema-level triggers?
What does an inner join do?
Which type of cursor is used to execute the dml statement?
what is 'mysqladmin' in mysql? : Sql dba
