SELECT COUNT(NAME_FIELD_NAME)AS NOMBER_OF_OCCURENCE FROM STUDENT WHERE NU

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 / venkat

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

Answer Posted / venkat

SELECT COUNT(NAME_FIELD_NAME)AS NOMBER_OF_OCCURENCE FROM
STUDENT WHERE NUMBER_OF_OCCURANCE >1;

Is This Answer Correct ?

3 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between "as" and "is" in an oracle stored procedure?

1046

How to join two tables in a single query using oracle?

1054

Whether any commands are used for months calculation? If so, what are they?

1139

What is an external table?

1084

How to concatenate two text values in oracle?

1159

Explain integrity constraint?

1209

Explain what are the uses of rollback segment?

1067

How do I know if oracle client is installed on windows?

1095

What is the difference between alert log file and tarce file ?

2232

How to experiment a data lock in oracle?

1112

Can we create database in oracle using command line ?

1134

How to convert characters to dates in oracle?

1152

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

how to join query for one source type is oracle another source type is sql server ?

2479

Please explain compound trigger in oracle?

1111