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
- 16911 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
Why do you use stored procedures and state some of its disadvantages?
Why cursor variables are easier to use than cursors?
How to generate query output in html format?
What is a cursor and what are the steps need to be taken?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Does oracle database need java?
What is ceil and floor in oracle?
How to convert dates to characters in oracle?
How to fetch the row which has the max value for a column?
What happens to the indexes if a table is recovered?
Write a syntax for update query in oracle?
How to use "for" statements in oracle?
Is oracle an operator?
What is a data dictionary and how can it be created?
What is a view and how is it different from a table?
