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.
- 11 Answers
- 13642 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
What is a schema in oracle?
How to get execution statistics reports on query statements?
How to define an external table with a text file?
Explain an index segment?
How to start an oracle instance?
What are a collation and state the different types of collation sensitivity?
What happens if you lost a data file?
How to do clean up if create database failed?
Are truncate and delete commands same? If so why?
Explain oracle data types with examples?
How to change system global area (sga) in oracle?
Is insert autocommit in oracle?
How remove data files before opening a database?
How different is ms access and oracle?
Can we use bind variables in oracle stored procedure?
