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

Why do we use %rowtype & %type in plsql?

0 Answers  

How can I create a table from another table without copying any values from the old table?

8 Answers  

Is delete faster than truncate?

0 Answers  

Can dml statements be used in pl/sql?

0 Answers  

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

How is sql used in oracle?

0 Answers  

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

What is 19 null in sql?

0 Answers  

How many types of literals are available in pl sql?

0 Answers  

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

explain access control lists. : Sql dba

0 Answers  

Why do we need cursor in pl sql?

0 Answers