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
How to execute a stored procedure?
How do you write an index?
what is sql? : Sql dba
What are the types of sql commands?
What are instead of triggers?
What is the difference between rollback and rollback to statements?
what is schema? : Sql dba
What is a sql statement?
what is the stuff function and how does it differ from the replace function? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is sqlerrm?
What has stored procedures in sql?
Is microsoft sql free?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is sql table?
