September 8, 2008 03:43am pdt

1. angelIII 891,543
2. ee_rlee 458,453
3. capricorn1 357,096
4. chapmandew 344,652
5. mark_wills 328,630
6. matthews... 191,846
7. aneeshatti... 190,096
8. Thomasian 170,076
9. jinesh_ka... 167,181
10. sdstuber 150,377
11. jimhorn 131,400
12. peter57r 124,305
13. DatabaseMX 113,347
14. harfang 111,183
15. frankytee 108,644
16. mwvisa1 96,405
17. hielo 94,350
18. boag2000 87,538
19. GRayL 86,734
20. TextReport 84,195
21. cactus_d... 79,446
22. ScottPletc... 79,436
23. dqmq 75,615
24. LSMCons... 74,800
25. BrandonG... 63,970

1. angelIII 1,636,876
2. capricorn1 691,208
3. matthews... 481,757
4. ee_rlee 458,453
5. aneeshatti... 400,803
6. chapmandew 344,652
7. mark_wills 328,630
8. peter57r 224,334
9. DatabaseMX 222,419
10. harfang 221,963
11. imitchie 215,310
12. jimhorn 211,920
13. dqmq 198,880
14. GRayL 192,565
15. jinesh_ka... 183,470
16. sdstuber 182,875
17. Thomasian 170,076
18. frankytee 158,892
19. Lowfatsp... 148,233
20. mbizup 140,947
21. ScottPletc... 132,541
22. DanielWilson 122,878
23. MikeToole 121,533
24. LSMCons... 116,015
25. appari 115,753

01.30.2008 at 01:00AM PST, ID: 23122126

	[x] Attachment Details

mysql select limit only integer

Asked by teera in SQL Query Syntax, MySQL

balanceborow.amout*.02 AS Interrest the out put is 800.2000 or 450.0200 how can I set the out put is interger 800.20 should be 801 or 450.0200 should be 451

SELECT balanceborow.wid, balanceborow.wname, balanceborow.amout, balanceborow.amout*.02 AS Interrest, balanceborow.DateBalance, balanceborow.amout
FROM balanceborow
WHERE balanceborow.wid =' $AccNo'Start Free Trial

Keywords: mysql select limit only integer

	Title
1	Where do I put logon.bat to get it to ru…
2	Define a specific integer range for a m…
3	interger index
4	sending a list of interger to a stored pr…
5	setting MYSQL rules
6	Select INTO unbound FormName.text …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

mysql select limit only integer

Asked by teera in SQL Query Syntax, MySQL

About this solution