Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17448 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / abrar yaseen
select student_name from student group by student_name
having count(OCCURANCE) > 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
State all possible different index configurations a table can possibly have?
How to revoke create session privilege from a user in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is oracle join syntax?
Why is oracle so popular?
How many types of synonyms in Oracle?
What privilege is needed for a user to create views in oracle?
How to rename a tablespace in oracle?
What is PL/SQL ?
How to write an inner join with the where clause in oracle?
How to change program global area (pga) in oracle?
How can windows applications connect to oracle servers?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to fetch the row which has the max value for a column?
What do you mean by a database transaction & what all tcl statements are available in oracle?
