SQL Query:
SELECT * FROM [sales] ORDER BY [SalesmanId] asc;
SalesmanId (
+
/
-
)
Timestamp (
+
/
-
)
Amount (
+
/
-
)
1
7/23/2002 11:43:00 AM
3000
1
7/24/2002 11:43:00 AM
2000
2
7/24/2002 11:43:00 AM
3000
2
7/23/2002 11:43:00 AM
3250
3
7/23/2002 11:43:00 AM
1200
3
7/24/2002 11:43:00 AM
2045
4
7/24/2002 11:43:00 AM
3085
4
7/23/2002 11:43:00 AM
1600
5
7/23/2002 11:43:00 AM
2000
5
7/24/2002 11:43:00 AM
3290
6
7/24/2002 11:43:00 AM
4900
6
7/23/2002 11:43:00 AM
1520
7
7/23/2002 11:43:00 AM
1840
7
7/24/2002 11:43:00 AM
2000
8
7/24/2002 11:43:00 AM
2700
8
7/23/2002 11:43:00 AM
1560
9
7/23/2002 11:43:00 AM
2140
9
7/24/2002 11:43:00 AM
1310
10
7/24/2002 11:43:00 AM
2075
10
7/23/2002 11:43:00 AM
1600
11
7/23/2002 11:43:00 AM
2150
11
7/24/2002 11:43:00 AM
3490
12
7/24/2002 11:43:00 AM
2340
12
7/23/2002 11:43:00 AM
1230
13
7/23/2002 11:43:00 AM
1360
13
7/24/2002 11:43:00 AM
1390
14
7/24/2002 11:43:00 AM
3245
14
7/23/2002 11:43:00 AM
1100
15
7/23/2002 11:43:00 AM
1900
15
7/24/2002 11:43:00 AM
4810
16
7/24/2002 11:43:00 AM
2710
16
7/23/2002 11:43:00 AM
1340
17
7/23/2002 11:43:00 AM
1320
17
7/24/2002 11:43:00 AM
3500
18
7/24/2002 11:43:00 AM
1355
18
7/23/2002 11:43:00 AM
2610
19
7/23/2002 11:43:00 AM
3210
19
7/24/2002 11:43:00 AM
2655
20
7/24/2002 11:43:00 AM
3220
20
7/23/2002 11:43:00 AM
3150
21
7/23/2002 11:43:00 AM
750
21
7/24/2002 11:43:00 AM
4000
22
7/24/2002 11:43:00 AM
4000
22
7/23/2002 11:43:00 AM
420
23
7/23/2002 11:43:00 AM
980
23
7/24/2002 11:43:00 AM
4000
24
7/24/2002 11:43:00 AM
2400
24
7/23/2002 11:43:00 AM
565
25
7/23/2002 11:43:00 AM
2100
25
7/24/2002 11:43:00 AM
1690
26
7/24/2002 11:43:00 AM
3000
26
7/23/2002 11:43:00 AM
2580
27
7/23/2002 11:43:00 AM
2450
27
7/24/2002 11:43:00 AM
2050
Click
here
to read about and download the source code.