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
- 13635 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 difference between sid and service name in oracle?
How will you differentiate between varchar & varchar2?
What are the components of logical database structure in oracle database?
How to login to the server without an instance?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What's dateware house and what's clustor with practicle example
What is an Oracle Instance?
How remove data files before opening a database?
How to use like conditions in oracle?
What are privileges and grants?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to invoke the original export import utilities?
How to load data from external tables to regular tables?
How would you go about verifying the network name that the local_listener is currently using?
What is different types of joins?
