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
Does sql backup shrink transaction log?
What is procedure and function?
What is a native sql query?
What are the benefits of triggers?
What are actual parameters and formal parameters?
Show code of a cursor for loop.
how to select first 5 records from a table? : Sql dba
What is a mutating table and a constraining table?
How do I run a sql query?
What is pivot table in sql?
Which is faster truncate or drop?
Explain dml and ddl?
what are all different types of collation sensitivity? : Sql dba
What is a delimiter in sas?
What are the advantages of pl sql?
