Posted by mGracz on 05/24/07 12:53

Welcome,

how can I alter following table in order to reduce neighbouring
duplicates (symbol, position, quantity, price).

Nr Symbol Position Quantity
Price Date
1. wz9999b 1 1.0
2500.0 2007-05-09 08:09:42.653
2. wz9999b 2 12.0
2500.0 2007-05-09 08:09:42.653
3. wz9999b 1 100.0
2590.0 2007-05-10 15:47:04.140
4. PZ0008VX 1 2280.884 2090.5500000000002 2007-05-16
12:43:12.403
5. PZ0008VX 1 2280.884 2102.0500000000002 2007-05-16
12:45:27.420
6. wz9999b 1 0.001
2500.0 2007-05-18 09:47:16.033
7. wz9999b 1 0.001
2500.0 2007-05-18 09:47:53.270
8. wz9999b 1 1.0
1.0 2007-05-22 12:35:07.893
9. PZ0008VX 1 2280.884 2102.0500000000002 2007-05-24
09:38:26.160
10. PZ0008VX 1 2280.884 2102.0500000000002 2007-05-24
09:38:38.800
11. wz9999b 1 0.001 2500.0
2007-05-24 12:35:07.207
12 wz9999b 1 0.002 2500.0
2007-05-24 12:35:14.987
13. wz9999b 1 0.001 2500.0
2007-05-24 12:38:07.207

In the result set I would like to get the rows number 6 and 10.

Any suggestions??

• Next in forum: Re: SUBSTRING in User Defined Function - Invalid column
• Prev in forum: Re: Query result sent via e-mail
• Thread view: Remove neighbouring duplicates

[Reply to this message]