SQL how to manipulate it? - KingPin's Forum
KPsDenKPsDen ArmoryImage HostingLegendz text RPGIp DisplayIRCFlash Arcade
Forum
      |        
Register
         The Vibrator (Posted By:djinnking - Replies:3 - Views:36)      « »     [epic] post you pic thread [/epic] (Posted By:wout - Replies:315 - Views:7490)      « »     Possable ganking? (Posted By:Texan - Replies:1 - Views:12)      « »     skinning (Posted By:landus - Replies:2 - Views:17)      « »     Sup sup (Posted By:The_FreeMan - Replies:1 - Views:13)      « »     [Check4SPAM] RE: Skinning?? (Posted By:landus - Replies:0 - Views:1)      « »     Where is everyone? (Posted By:Enfuego - Replies:10 - Views:135)      « »     Five Friends Vote (Posted By:redemption - Replies:3 - Views:57)      « »     Machinima.com Music Video (Posted By:Headshot - Replies:14 - Views:168)      « »     Guilds? (Posted By:redemption - Replies:1 - Views:25)      « »     
KingPin's Forum
 
K.P.s.N. Register vbBux / KPs Mall Bugs Blogs FAQ Search Today's Posts Mark Forums Read Donate
Go Back   KingPin's Forum > KP's Network Forum > RSS News
Reload this Page SQL how to manipulate it?
 


RSS News This is a discussion on SQL how to manipulate it? in the RSS News;
Description: I entered this SQL command for a specific answer, I did get the answer but, it's too long how do ...

Reply
 
LinkBack Thread Tools
SQL how to manipulate it?
(#1 (permalink))
Old
phoenix2367 is Offline
Private
Points: 190, Level: 2 Points: 190, Level: 2 Points: 190, Level: 2
Activity: 0% Activity: 0% Activity: 0%
phoenix2367 is an unknown quantity at this point
 
phoenix2367
Rupees: 67.00
Bank: 500.00
Total Rupees: 567.00
 
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Dec 2007
SQL how to manipulate it? - December 13th, 2007

I entered this SQL command for a specific answer, I did get the answer but, it's too long how do I shorten it, if anyone knows it would be great...
Example Code entered:
SELECT ENAME, JOB, SAL, COMM, SAL+COMM, 100*(COMM/(SAL+COMM))FROM EMP WHERE COMM IS NOT NULL;
Result for the "100*(COMM/(SAL+COMM))" =52.8301886792452830188679245283018867925
How do I shorten this to maybe = 52.8301.
Please help, thank you...

 
Reply With Quote
Reply

Bookmarks

Tags
manipulate, sql

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Rupees Per Thread View: 1.00
Rupees Per Thread: 15.00
Rupees Per Post: 5.00
Forum Jump



Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
Copyright 2004-2009 KPsN


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81