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
17145 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 to export several tables together?

1056

What is a relational database management system?

1127

what are actual and formal parameters?

1113

How can we find out the current date and time in oracle?

1099

What are the different types of failures that occur in Oracle database?

1076

various types of hints and their usage

2707

What suggestions do you have to reduce the network traffic?

974

Explain the use of inctype option in exp command.

1041

How many categories of data types?

1003

What are the attributes of cursor?

1061

What language does oracle use?

1120

what are bitmap indexes? How does they work?

2266

How to sort the query output in oracle?

1033

What is control file used for?

1225

How to start your 10g xe server?

1050