Calculating percentages

Question

Calculating percentages

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 1

Be careful though ... the majority of this post used 'imlpicit' conversions. Experience has taught that 'implicit' (like 'default') can get you into trouble when you least expect it. Just because SQL is a higher level language does not mean we have to forget about basic data type compatibilities, converting to the same type or casting.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Ninja's_RGR'us

SSC Guru

Points: 294069

September 22, 2005 at 2:40 pm

#592403

Good point... I'll try to see to it .

jbaker SSC Rookie Points: 29 More actions · Answer 3

jbaker

SSC Rookie

Points: 29

September 22, 2005 at 3:13 pm

#592417

Guys, this is 7th grade math, not SQL specific.

Sergiy SSC Guru Points: 110208 More actions · Answer 4

.0 forces real calculation.

If you need float precision type .00000.

And finally, use variables. Do you actually remember what they told you on programmers courses?

_____________
Code for TallyGenerator

cibaoweb Newbie Points: 2 More actions · Answer 5

If you are trying to get what percentage is 426 out of 852 then

Try this out..

select (426 + .0)/ (852) * 100

Result

50.000

Don't tell me it doesn't work because I've tried it and it's the correct syntax.

cibaoweb Newbie Points: 2 More actions · Answer 6