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
16617 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 assign values to data fields in record variables?

973

What are the logical operations?

1063

Use of an integrity constraint is better to validate data. Explain

974

What are dml statements in oracle?

1040

How many types of auditing in Oracle?

980

How to enter a new row into a table interactively?

960

How do I uninstall oracle client from windows?

960

What is Redo Log Buffer in Oracle?

1122

How to change system global area (sga) in oracle?

957

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1944

How to store pictures on to the database?

923

How to resolve the ORA-39133 error in Oracle?

1031

How to create an oracle database?

976

How to create a new tablespace in oracle?

932

What is meant by raw datatype?

1003