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?
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 we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is query syntax?
How do you get column names only for a table (sql server)?
What is coalesce in sql?
Why do we create views in sql?
How many triggers can be applied to a table?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is schema in sql example?
What is the usage of sql functions?
How do you update a sql procedure?
Is nosql relational?
What are inner and outer joins examples of both?
Does sql*plus have a pl/sql engine?
What do you mean by stored procedures? How do we use it?
What is synchronized subquery?