SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD

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 / u.radha

11 Answers
17446 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / u.radha

SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD_NAME
HAVING COUNT(*) > 1

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create an oracle database manually?

1129

Explain the types of exception?

1194

How to define default values for formal parameters?

1093

IS it possible to built the oracle database without setting the kernal parameters?

2393

How to create tables for odbc connection testing?

1204

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1066

What is instant client oracle?

1072

Explain the different normalization forms?

1156

Is oracle a programming language?

1037

What is a read write transaction in oracle?

1131

How to delete a user account in oracle?

1021

What is a table in oracle?

1020

Write a trigger example in oracle?

1113

How to estimate disk space needed for an export job?

1105

What privilege is needed for a user to connect to oracle server?

1033