Interested to Buy Any Domain ? << Click Here >> for more details...
one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000
So my requirement is i want output like
SAL
---
1000
2000
3000
it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u
write query?
- 13 Answers
- 24019 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / yaswanth
select salary from emp where rowid NOT IN(select max(rowid) from emp GROUP BY salary);
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
What is the use of prepared statement?
How many types of normalization are there?
How many subqueries can be nested in a statement?
What problem one might face while writing log information to a data-base table in pl/sql?
Which certification is best for sql?
Are sql connections encrypted?
What is data control language (dcl)?
What are the advantages of stored procedure?
What is linq to sql?
What are schema-level triggers?
what is a foreign key ? : Sql dba
How to check if a column is nullable before setting to nullable?
Which join is like an inner join?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How to create an array in pl/sql?
