RSS
DaniWeb Home
>
Forums
>
Web Development
>
Databases
>
MS SQL
How to get the result for smaller number divide larger number?
Please support our
MS SQL
advertiser:
Programming Forums
Thread Tools
Display Modes
Views:
8522
| Replies:
10
|
Solved
•
•
•
•
Previous Post in Thread
Next Post in Thread
•
•
Join Date: Jun 2005
Posts: 1
Reputation:
Rep Power:
0
Solved Threads: 0
330m
Offline
Newbie Poster
How to get the result for smaller number divide larger number?
#
1
Jun 10th, 2005
Hi All,
When I run the query:
select (100/50)
It give me "2"... good.
But when I run the query:
select (50/100)
I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
330m
View Public Profile
Send a private message to 330m
Find all posts by 330m
Quick Reply to Thread
•
•
•
•
Only community members can participate in forum threads. You must
register
or log in to contribute.
Register
•
•
•
•
Currently Active Users Viewing This Thread: 1
(0 members and 1 guests)
•
•
•
•
Thread Tools
Display Modes
Show Printable Version
Email this Page
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Related Features
•
•
•
•
MS SQL Forum
Databases Forum
Web Development Forum
Web Development Blog
MS SQL Forum Highlights
Today's Posts
MS SQL
Databases
Web Development
All Forums
Unanswered Threads
MS SQL
Databases
Web Development
All Forums
Blog Tag Cloud
•
•
•
•
ajax
asp
database
developer
development
hacker
microsoft
msdn
news
office
security
software
sql
survey
vista
All Recent Tags
Similar Threads
Computer Architecture Reference
(Computer Science and Software Design)
Factorial of a number
(C)
Prime Numbers - Help its for college
(Visual Basic 4 / 5 / 6)
Cannot get PAIR::big to just display greater number
(C++)
Other Threads in the MS SQL Forum
Previous Thread:
SQL Syntax
Next Thread:
Nested Queries
Forums
|
Blogs
|
Tutorials
|
Code Snippets
|
Whitepapers
|
RSS Feeds
|
Advertising
All times are GMT -4. The time now is
10:31 am
.
Newsletter Archive
-
Sitemap
-
Privacy Statement
-
Acceptable Use Policy
-
Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC