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
17459 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 is a named program unit?

1137

What do you mean by merge in oracle?

1029

What are the common oracle dba tasks?

1201

Can we create database in oracle using command line ?

1132

How to add a new column to an existing table with a default value?

1056

What is a partition in oracle?

1204

How to drop an existing view in oracle?

992

What is ADDM Advisor in Oracle?

1224

Is postgres faster than oracle?

1084

Where are the settings stored for each instance in oracle?

1153

what is IDE,DMV in sql server?

2880

Explain user account with reference to oracle.

1029

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2000

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2360

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398