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
- 14429 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 actual and formal parameters?
Can group functions be mixed with non-group selection fields?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
defination of bitmap index
Explain what are the uses of rollback segment?
What are the differences between blob and clob in oracle?
How to load data through external tables?
Describe an oracle table?
Explain what are synonyms used for?
What happens if the update subquery returns multiple rows?
How to do a full database export?
Please explain oracle data types with examples?
query optmization techniques and quwry analyser+projects+ppts
State the difference between a primary key and foreign key?
