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 many groups of data types? : Sql dba
Why is nosql good?
What are the types of variables use in pl sql?
What is a native sql query?
What is the use of index in hive?
What is multiple partition?
What are the set operators in sql?
How can we optimize a sql query?
who introduced sql?
What is natural join in sql?
What is the difference between microsoft access and sql server?
Is delete faster than truncate?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is the use of & in pl sql?
Why do we use function in pl sql?