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
- 16633 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkat
SELECT COUNT(NAME_FIELD_NAME)AS NOMBER_OF_OCCURENCE FROM
STUDENT WHERE NUMBER_OF_OCCURANCE >1;
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
How to create an oracle database manually?
In which language oracle has been developed?
How to delete a column in an existing table in oracle?
What are the advantages of oracle?
How to invoke the original export import utilities?
What is dual table oracle?
What are the uses of linked server and explain it in detail?
What do you understand by database schema and what does it hold?
What are the set operators union, union all, minus & intersect meant to do?
How to use "startup" command to start default instance?
Can we write dml statement in function in oracle?
How to run create database statement?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to bring a tablespace online?
What is a sub query and what are the different types of subqueries?
