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 / mohannad amarneh
select distinct(sal) from my_table;
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Can you have more than one key in a database?
what is acid property in database? : Sql dba
how mysql optimizes distinct? : Sql dba
Explain what is a field in a database and record in a database?
what are sequences
how many sql dml commands are supported by 'mysql'? : Sql dba
How long it takes to learn pl sql?
Explain the advantages and disadvantages of stored procedure?
What is the difference between an inner and outer join?
What is group by in sql?
Which query operators in sql is used for pattern matching?
What is a Mapplet?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
What is indexing oracle sql?