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
17445 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 proxy method?

1021

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2332

How do I manually create a database in oracle?

1068

What is SQL Tuning Advisor in Oracle?

1248

How to use existing values in update statements using oracle?

1110

How many types of table in Oracle?

1172

How view is different from a table?

1081

Explain the use of record length option in exp command.

1117

What is parameterized cursor in oracle?

1221

Why is oracle database so popular?

1069

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2089

what are the default admin accounts in Oracle 10g ?

1019

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2318

Can multiple cursors being opened at the same time?

1115

How to connect asp pages to oracle servers?

1119