write a query to dispaly those name who is more than one in
student table?
example- in a student table sandeep kumar comes 4 times,
rakesh kumar comes 2 times, ajit kumar comes 1 times so
query will display sandeep kumar and rakesh kumar single
times.
- 11 Answers
- 14433 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / u.radha
SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD_NAME
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
how to handle exceptions in post production
Explain the use of indexes option in exp command.
material view and view disadvantages?
In what script is snap$ created? In what script is the scott/tiger schema created?
List out the types of joins.
What is the disadvantage of User defind function?
How to invoke the original export import utilities?
What is the difference between formal parameters and actual parameters?
How to change user password in oracle?
How to apply filtering criteria at group level in oracle?
Explain what are the type of synonyms?
Is it possible to split the print reviewer into more than one region ?
How to open a cursor variable?
Explain the use of Merge statement in oracle 11g
What are the different types of trigger and explain its various uses and functions?
