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
- 11088 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 are types of joins?
What is data manipulation language?
How does postgresql compare to mysql?
what are ddl statements in mysql? : Sql dba
What is an inner join sql?
Is like operator in sql case sensitive?
define data blocks ? : Sql dba
What are different types of tables in sql?
How to read xml file in oracle pl sql?
How long it takes to learn pl sql?
Which sql statement is used to return only different values?
Is primary key clustered index?
What is nosql example?
What is the difference between nested table and varray?
What is memory optimized?
