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
- 17447 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 we need oracle client?
Is rowid unique in oracle?
What is the purpose of save points in oracle database?
What are the original export and import utilities?
How to assign values to variables?
What are the limitations oracle database 10g xe?
What is Undo Management Advisor in Oracle?
Whether any commands are used for months calculation? If so, what are they?
What is the use of file param in imp command?
How do I spool in oracle?
What is a server parameter file in oracle?
What is partitioned table in Oracle?
Which is better Oracle or MS SQL? Why?
Give the various rollback segment states.
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
