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
- 16964 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / seethal
select stu_name from(select stu_name,count(stu_name) sc from
stu_table group by stu_name)where sc > 1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are transaction isolation levels supported by oracle?
What are advantages of dateset in datastage?
Explain what are clusters?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is define in oracle?
Explain what are the type of synonyms?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to invoke the data pump import utility?
Why do we need integrity constraints in a database?
What is ordinary table in oracle?
Is the After report trigger fired if the report execution fails ?
what are steps for interface? where is exchange rate defined in which table?
What is a sub query and what are the different types of subqueries?
Can we store pictures in the database and if so, how it can be done?
What are group functions in oracle?
