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
- 16631 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neha_gupta
select ename,count(1) from student
group by ename
having count >1
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / u.radha
SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD_NAME
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / gourav
select first_name,count(*) from employees
group by first_name
having count(*)>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / dheer
select v_id from dup where rowid not in (select max(rowid)
from dup group by v_id);
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / cheeku
select distinct NM from
(
(select name from student_tbl M where exists
(select 1 from student_tbl S where
S.name = M.name and
S.rowid <> M.rowid)
)NM;
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / valmiki sreenivasulu
A)select sname from student group by sname;
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / abrar yaseen
select student_name from student group by student_name
having count(OCCURANCE) > 1
| Is This Answer Correct ? | 0 Yes | 2 No |
What is Parallel Server ?
How to drop a tablespace?
How to recover a dropped index?
Which is better Oracle or MS SQL? Why?
How to sort the query output in oracle?
What is cluster Key ?
Can group functions be used in the order by clause in oracle?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is the difference between count (*), count (expression), count (distinct expression)?
How to revoke create session privilege from a user in oracle?
What to do if dba lost the system password?
What is memory advisor in Oracle?
Oracle General 
