A)select sname from student group by sname;

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 / valmiki sreenivasulu

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

Answer Posted / valmiki sreenivasulu

A)select sname from student group by sname;

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I connect to oracle database?

1028

How to download oracle database 10g xe?

960

What are the attributes of the cursor?

937

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

974

How can you use check constraints for self referential integrity?

920

How to load a large xml file?

1005

How to write numeric literals in oracle?

1129

How to connect asp pages to oracle servers?

1007

What is data type in oracle?

1043

Is it possible to split the print reviewer into more than one region ?

2223

What is the implicit cursor in oracle?

1039

What is the difference between translate and replace in oracle?

1115

what is Single Byte Overhead...?

2500

How to declare a local variable?

1055

How to open a cursor variable?

975