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
- 16629 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / gourav
select first_name,count(*) from employees
group by first_name
having count(*)>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is dual table oracle?
What happens if variable names collide with table/column names?
Is oracle a language?
Explain view?
How to check the oracle tns settings?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different types of synonyms?
What is where clause in oracle?
How to view the data files in the current database?
Can sub procedure/function be called recursively?
What is an oracle database table?
How to create a new table in your schema?
Can I create users through internet explorer in oracle 10g?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Explain constraining triggers.
