Answer / yaswanth

select distinct(SAL) as SAL from table_name;

Answer / yaswanth

delete from employees where rowid NOT IN(select max(rowid) from employees GROUP BY salary)

Answer / mohannad amarneh

select distinct(sal) from my_table;

Answer / annalakshmi.s

select distinct(salary) from tablename

Example:

employee is the table name

salary is the column name means

select distinct(salary) from employee

Answer / hiya

select n from (select row_number()over (partition by n order
by n) r,n from test group by n having count(*)>1)

Answer / manju

Select sal from emp group by sal having count(*)>=1

Answer / swastik

DELETE FROM Emp A
WHERE ROWID NOT IN
                  (
                   SELECT MIN(ROWID)
                   FROM Emp B
                   WHERE A.Sal = B.Sal
                  )

Answer / suma

can we use group by?

Answer / sandeep sudunagunta

Select sal form from my_table group by sal having count(*)>1

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

what is self join and how it works??

2 Answers   Infosys,

How do I get sql certification?

0 Answers  

What are all types of user defined functions?

0 Answers  

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

What does plv msg allows you to do?

0 Answers  

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

How do you update a table in sql?

0 Answers  

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  

what is 'mysqlcheck'? : Sql dba

0 Answers  

What is Referential Integrity?

3 Answers  

Mention what are different methods to trace the pl/sql code?

0 Answers