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 only how should u
write query?
- 9 Answers
- 10973 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / annalakshmi.s
select distinct(salary) from tablename
Example:
employee is the table name
salary is the column name means
select distinct(salary) from employee
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql table? Why is it used?
What is pivot in sql?
Which is the correct statement about truncate and delete?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
How do I view tables in mysql?
What is the max nvarchar size?
What is the use of <> sql?
How many commands are there in sql?
How many tables can a sql database have?
Define concurrency control. : Transact sql
How can you select unique records from a table?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Why is sql better than hql?
What is difference between hql and native sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
