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
- 13634 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / abc
SELECT name FROM student_table
GROUP BY name
HAVING ( COUNT(name) > 1 );
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many file formats are supported to export data?
What happens if you lost a data file?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to write an inner join with the where clause in oracle?
What is a cognitive schema?
Explain the difference between sql and oracle?
Explain rename?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to initialize variables with default values?
Explain the use of owner option in exp command.
What are the varoius components of physical database structure of oracle database?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What happens to the current transaction if the session is killed?
How do I find my oracle client driver version?
11. Display the client number and name and the client number and name of the person who referred that client.
