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 single byte over head in oracle..?
what is the difference between a having clause and a where clause? : Sql dba
Is sql the best database?
What is indexing in sql and its types?
Does truncate require commit?
What are all the different normalizations?
Are stored procedures faster than queries?
Write a unique difference between a function and a stored procedure.
What is a pragma statement?
What is parallel hint?
Is like operator in sql case sensitive?
What is union, minus and interact commands?
What is user in sql?
How many types of functions are there in sql?
How to select 10 records from a table?