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
16613 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

What is procedure overloading in oracle?

991

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1668

how may join possible between (requisition with purchase order)

2167

What are the parameters that we can pass through a stored procedure?

996

What are transaction isolation levels supported by oracle?

994

Is primary key indexed by default in oracle?

928

How do we display rows from the table without duplicates?

918

Define oracle database

991

What are the uses of Database Trigger ?

1623

What do database buffers contain?

957

Explain oracle 12c new features for developers?

993

What do you understand by a database object?

987

Explain the truncate in oracle?

909

What is proxy method?

928

definition of cluster and non-clustered index?

2958