select distinct student_name from student;

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
16910 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / u.radha

select distinct student_name from student;

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1001

Explain the use of tables option in exp command.

1096

What is difference between sid and service name in oracle?

941

What are the differences between primary key and unique key?

987

What is the recommended interval at which to run statspack snapshots, and why?

2897

Why do we use bulk collect in oracle?

1043

What are the uses of Database Trigger ?

1682

What are the ansi data types supported in oracle?

933

Explain the importance of .pll extension in oracle?

985

Design database draw er diagram for a certain scenario ?

4561

Explain the blob datatype?

1056

What is null value in oracle?

1073

Â What are the oracle DML commands possible through an update strategy?

1041

what is a Nested Loop join?

2080

Can you tell me how to add new column in existing views?how?How is possible?

1419