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
- 11037 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / manju
Select sal from emp group by sal having count(*)>=1
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between syntax error and runtime error?
What is insert command in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
how to create a new table in mysql? : Sql dba
Difference between truncate, delete and drop commands?
How do I find duplicates in the same column?
What is the syntax to add a record to a table?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is query cache in mysql? : Sql dba
what are all types of user defined functions? : Sql dba
What are transaction and its controls?
how to use case expression? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are the different types of functions in sql?
What is over () in sql?
