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
- 11352 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / hiya
select n from (select row_number()over (partition by n order
by n) r,n from test group by n having count(*)>1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql procedures and functions?
Explain ttitle and btitle.
What is the difference between delete, truncate and drop command?
Do ddl statements need commit?
what is a trigger? : Sql dba
What is a composite primary key?
What is a temporal data type?
What is before trigger?
How do you optimize a stored procedure query?
What is cursor in pl sql with examples?
What is difference between sql function and stored procedure?
Can we join more than 2 tables in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is sql resultset?
How to pipe multiline string to isql?
