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
Which version of sql do I have?
What are actual parameters and formal parameters?
What is clustered and nonclustered index in sql?
What is interval partition?
What is difference between sql and excel?
What is assignment operator in pl sql?
Which nosql database is best?
What are the benefits of triggers?
Explain the difference between sql and mysql.
What sql database should I use?
Is a foreign key always unique?
How do you delete duplicates in sql query using rowid?
How do you run a query?
how to get @@error and @@rowcount at the same time? : Sql dba
Is sql easier than java?
