select ename,count(1) from student group by ename having count >1

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.

Question Posted / neha_gupta

11 Answers
16942 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

Please Help Members By Posting Answers For Below Questions

What are the differences between date and timestamp in oracle?

1029

What is an Oracle Instance?

1105

How much memory your 10g xe server is using?

1087

What is the best way to do multi-row insert in oracle?

1049

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2447

How to drop a stored procedure in oracle?

1034

What is oracle open database communication (odbc)?

1009

how the indexes are stored in the Oracle Database?

2257

How to revoke create session privilege from a user in oracle?

998

How to write an inner join with the where clause in oracle?

1030

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2217

How are extents allocated to a segment?

1107

How to retrieve data from an cursor to a record?

1074

Does oracle database need java?

985

How to drop an existing view in oracle?

933