SQLTeam.com | Weblogs | Forums

Need a SQL Query

The Table below has two fields "ID" and "Current"

ID Current
1 2.73
2 2.71
3 2.22
4 2.66
5 3.02
6 1.99
7 7.29
8 2.12
9 5.11
10 2.06
11 0
12 0
13 0
14 0
15 0
16 0
17 0
18 0
19 3.02
20 1.99
21 7.29
22 2.12
23 5.11
24 0
25 0
26 0
27 0

I want a Query which returns:

ID Current
1 2.73
10 2.06
11 0
18 0
19 3.02
23 5.11
24 0
27 0

Thank You very much

Said

Duplicate of Need a SQL Query

Locking this thread.