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
- 14430 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
Explain alias?
What is a nvl function?
How to convert times to characters in oracle?
What happens to the current transaction if the session is ended?
How do I find my oracle client driver version?
Explain the use of constraints option in exp command.
What the is the diff between local index and global index. give some example.
How many types of tables are there in oracle?
Is postgres faster than oracle?
Explain the difference between sap and oracle?
How do I recompile a procedure in oracle?
Please explain oracle data types with examples?
How to drop an index?
Explain the use of consistent option in exp command.
What is hash cluster in oracle?
