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 / suma
can we use group by?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why truncate is faster than delete?
What is meant by cursor in sql?
What are the built in functions of sql?
What is java sql connection?
Write a sql query to convert all character to uppercase after hypen.
What is difference between sql and mysql?
What does <> sql mean?
what are the types of subquery? : Sql dba
How many sql databases can you have on one server?
What are string functions in sql?
Write a sql query to find the names of employees that begin with ‘a’?
What is a pl/sql block?
how many sql dml commands are supported by 'mysql'? : Sql dba
Give the order of sql select?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba