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 forward declaration in pl sql?

0 Answers  

What is meant by temporal data?

0 Answers  

How can you create Cursor with parametres ?

3 Answers  

Mention what pl/sql package consists of?

0 Answers  

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

what are all the different types of indexes? : Sql dba

0 Answers  

How is indexing done in search engines?

0 Answers  

What is an invalid partition table?

0 Answers  

How do we use distinct statement? What is its use?

0 Answers  

Explain what is a column in a table?

0 Answers  

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers