Hi,
here is my data
id |name |salary |dept
1 |a |1000 | 10
2 |b |2000 | 20
3 |c |3000 | 30
1 |a |1000 | 10
3 |c |3000 |30

in above data i want to delete duplicate records(id 1,id 3)
How can i delete in vertica?