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

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

1067

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

How to define an oracle cursor variable?

1027

What is the difference between translate and replace in oracle?

1165

How to convert a date to char in oracle? Give one example.

1068

What are the different types of synonyms?

1140

What is difference between cartesian join and cross join?

1088

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

How to use attributes of the implicit cursor in oracle?

1008

How remove data files before opening a database?

1072

What is backup in Oracle?

1004

How to synchronize 2 schema's objects?

2181

What is a read only transaction in oracle?

1029

What does sharding mean?

1000

What is the usage of synonyms?

1143