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
17103 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

Explain the use of parfile option in exp command.

1070

Design database draw er diagram for a certain scenario ?

4579

How to define a variable of a specific record type?

1078

Write a syntax for update query in oracle?

1036

Will you be able to store pictures in the database?explain.

995

Explain what does a control file contain?

1103

What is an Oracle Instance?

1126

Write a trigger example in oracle?

1068

11. Display the client number and name and the client number and name of the person who referred that client.

2340

What is hot backup and logical backup?

1051

Difference between oracle's plus (+) notation and ansi join notation?

1108

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

How to use "in out" parameter properly?

1051

What is oracle data type?

969

What is java oracle used for?

1030