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
- 17147 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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is program global area (pga) in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
how to handle exceptions in post production
What is a table index in oracle?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
What happens if you lost a data file?
State all possible different index configurations a table can possibly have?
What is a nested table and how is it different from a normal table?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
how to get count of tables in particular database in Oracle?
Oracle General 
