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 in the table
permanently and i want output in the above formatow should u
write query?
Answer Posted / priya
select DISTINCT sal from emp;
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is the difference between execution of triggers and stored procedures?
how to use myisamchk to check or repair myisam tables? : Sql dba
how to check myisam tables for errors? : Sql dba
How many tables can you join in sql?
How do you define a foreign key?
How run sql*plus commands that are stored in a local file?
What is embedded sql in db2?
what is the difference between truncate and delete statement? : Transact sql
What are user defined functions?
What are the different types of joins in sql?
What is example of database?
What is online transaction processing (oltp)?
what is the difference between group by and order by in sql? : Sql dba
How do you remove duplicate records from a table?
What is graph sql?