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
- 13639 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
Explain the use of rows option in imp command.
How to get a list of all user accounts in the database?
How would you go about verifying the network name that the local_listener is currently using?
How to invoke the data pump export utility?
How to install oracle database 10g xe?
Explain the blob datatype?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain about the analyze command in oracle?
How to connect the oracle server as sysdba?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
List the types of joins used in writing subqueries?
What are privileges and grants?
What are the uses of synonyms?
How do I limit the number of oracle database connections generated by weblogic server?
Is oracle an open source?
