Answer / neha_gupta

select ename,count(1) from student
group by ename
having count >1

Answer / u.radha

SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD_NAME
HAVING COUNT(*) > 1

Answer / gourav

select first_name,count(*) from employees
group by first_name
having count(*)>1;

Answer / seethal

select stu_name from(select stu_name,count(stu_name) sc from
stu_table group by stu_name)where sc > 1;

Answer / u.radha

select distinct student_name from student;

Answer / dheer

select v_id from dup where rowid not in (select max(rowid)
from dup group by v_id);

Answer / abc

SELECT name FROM student_table
GROUP BY name
HAVING ( COUNT(name) > 1 );

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;

Answer / valmiki sreenivasulu

A)select sname from student group by sname;

Answer / abrar yaseen

select student_name from student group by student_name
having count(OCCURANCE) > 1

what is the difference between simple view and complex view?

13 Answers  

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it

2 Answers  

Does facebook use oracle?

0 Answers  

Explain the use of file option in exp command.

0 Answers  

how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,

What is a Public Synonyms ?

1 Answers  

how to get count of tables in particular database in Oracle?

3 Answers  

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

0 Answers  

What is an Index Segment ?

2 Answers  

Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 Answers