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
16963 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 format trigger?

2058

What is an oracle data file?

1083

What is a initialization parameter file in oracle?

1020

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3315

Can I create users through internet explorer in oracle 10g?

1068

How to compare dates in oracle sql?

1088

How to export your connection information to a file?

1117

How many types of auditing in Oracle?

1020

What is BBED in Oracle?

1139

What is dual table oracle?

971

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2116

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2170

Explain what are the type of synonyms?

1097

How to use subqueries in the from clause in oracle?

1088

What is set verify off in oracle?

1078