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
- 17122 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 |
State and explain about oracle instance?
how to hide the stored procedure inside a package
How do I spool to a csv formatted file using sqlplus?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are the components of logical database structure in oracle database?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
How can you Enforce Referential Integrity in snapshots ?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
How to assign a table row to a record variable?
Where do we use decode and case statements?
Is oracle a relational database?
How to rename a column in an existing table?
Oracle General 
