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
- 13637 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / neha_gupta
select ename,count(1) from student
group by ename
having count >1
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to create an oracle testing table?
How to pass a cursor variable to a procedure?
How index is implemented in oracle database?
How to rename an existing table?
What is oracle analytical function?
How to initialize variables with default values?
How to check database size in Oracle?
How can I see all tables in oracle?
Is oracle an operator?
Give the advantages and disadvantages of clusters.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What are the different types of synonyms?
Explain self joins in oracle?
What is a system tablespace and when it is created?
what is normalisation?what are its uses?
