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
- 14428 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select ename,count(1) from student
group by ename
having count >1
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is an oracle data file?
what is the difference between data migration and production migration.
How to create a new oracle data file?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to commit the current transaction in oracle?
Why we use bulk collect in oracle?
What is oracle in java?
How to create an oracle testing table?
What is the quickest way to fetch the data from a table?
What is the difference between I and G in Oracle?
Explain about achiever in sql?
What language does oracle use?
How does the on-delete-cascade statement work?
What is the difference between 10g OEM and 11g OEM?
