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
- 11019 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
Can there be more than one function with a similar name in a pl/sql block?
What is cursor status?
How do you update a sql procedure?
what is the command line end user interface - mysql? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is a primary key? Explain
What is the difference between Union and Union all. Which is faster.
What is a composite primary key?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is a stored procedure in sql with example?
What is Materialized View? In What Scenario we Use Materialized View?
Does sqlite need a server?
Mention what plvcmt and plvrb does in pl/sql?
what is uncommittable transactions? : Transact sql
What are all ddl commands?
