절사 함수 반올림,반내림

절사 함수
SELECT FLOOR(10.1234)
쿼리 실행 후 결과 : 10
– 반올림 함수
SELECT ROUND ( 1234.5678 , 2 ) = 1234.57 — 반올림 변수가 + 2 이므로 소수점 아래 둘째자리 까지 반올림
SELECT ROUND ( 1234.5678 , -2 ) = 1200 — 반올림 변수가 -2 이므로 소수점 위 둘째자리까지 반올림
SELECT ROUND ( 1234.5678, 1, 4 ) = 1234.5 — 세 번째 인자가 0이 아니므로 절삭
SELECT ROUND ( 1234.5678, 1, 0 ) = 1234.6 — 세 번째 인자가 0이므로 반올림
주의할점 :
1의단위 까지 나타내고 싶은 경우 절삭과 반올림 값이 달라질 수 있다
SELECT ROUND ( 1234.5678, 0 ) = 1235 — 반올림 변수가 0이므로 1의 자리까지 반올림
SELECT ROUND ( 1234.5678, 0, 1 ) = 1234 — 세 번째 인자가 0이 아니므로 절삭

“절사 함수 반올림,반내림”의 128개의 댓글

  1. Hmm it looks like your blog ate my first comment (it was super long) so I guess I’ll
    just sum it up what I wrote and say, I’m thoroughly enjoying your blog.
    I too am an aspiring blog writer but I’m still new to
    the whole thing. Do you have any recommendations for novice blog writers?
    I’d definitely appreciate it.

  2. I do trust all the ideas you’ve offered on your post.

    They are really convincing and will certainly work.
    Nonetheless, the posts are very short for novices.

    May you please prolong them a bit from subsequent time?
    Thanks for the post.

  3. Write more, thats all I have to say. Literally, it seems as
    though you relied on the video to make your point.
    You definitely know what youre talking about, why throw away your intelligence on just posting videos to
    your site when you could be giving us something informative to read?

  4. I just want to tell you that I’m all new to weblog and really savored this web-site. Most likely I’m want to bookmark your site . You amazingly come with beneficial posts. Thanks a bunch for revealing your website.

  5. A person essentially assist to make seriously articles I would state. That is the first time I frequented your website page and so far? I amazed with the research you made to make this particular publish extraordinary. Magnificent activity!

  6. Woah! I’m really enjoying the template/theme of this blog. It’s simple, yet effective. A lot of times it’s very difficult to get that “perfect balance” between usability and appearance. I must say you have done a excellent job with this. Also, the blog loads super fast for me on Firefox. Exceptional Blog!

  7. I think this is one of the most vital info for me. And i am glad reading your article. But want to remark on few general things, The website style is ideal, the articles is really excellent : D. Good job, cheers

  8. I do trust all of the ideas you’ve introduced for your post. They are very convincing and will definitely work. Nonetheless, the posts are very brief for starters. May you please lengthen them a little from subsequent time? Thank you for the post.

  9. I just want to tell you that I am just newbie to blogs and certainly savored your web site. More than likely I’m going to bookmark your website . You certainly come with impressive well written articles. Bless you for revealing your webpage.

  10. Please let me know if you’re looking for a article author for your blog. You have some really good articles and I believe I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Thanks!

  11. I precisely desired to say thanks yet again. I’m not certain the things that I would have used without the strategies revealed by you directly on this concern. It absolutely was a real terrifying situation for me personally, but encountering a professional manner you dealt with it made me to leap with joy. I am just thankful for this support and believe you know what a powerful job that you are doing educating the mediocre ones through the use of your web site. More than likely you have never encountered any of us.

  12. Once I originally commented I clicked the -Notify me when new comments are added- checkbox and now every time a comment is added I get 4 emails with the identical comment. Is there any method you’ll be able to remove me from that service? Thanks!

  13. I precisely wished to appreciate you again. I am not sure the things that I would have gone through in the absence of the actual recommendations shared by you over that problem. Previously it was a real intimidating matter in my circumstances, but spending time with a new specialised tactic you managed that forced me to weep with happiness. I will be grateful for your guidance and thus trust you really know what an amazing job that you are carrying out instructing others via a web site. More than likely you haven’t encountered any of us.

  14. I do enjoy the way you have framed this specific challenge and it does indeed present us a lot of fodder for consideration. Nonetheless, because of just what I have personally seen, I just simply trust when the actual responses pack on that folks remain on point and in no way start on a soap box regarding some other news of the day. All the same, thank you for this excellent piece and while I can not necessarily agree with the idea in totality, I respect your viewpoint.

  15. When I initially left a comment I appear to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I recieve four emails with the exact same comment. Is there an easy method you are able to remove me from that service? Thanks a lot!

  16. I just want to mention I’m new to blogs and absolutely liked this web blog. Almost certainly I’m likely to bookmark your blog post . You amazingly have amazing articles. Thanks a bunch for revealing your website.

  17. Fabulous piece of writing! Genuinely savored often the examining. I hope to study significantly more away from you. In my opinion you may have amazing information and even imaginative and prescient vision. I’m greatly fascinated this particular answers.

  18. You’re so cool! I do not think I’ve read something like that before. So good to discover someone with some unique thoughts on this subject matter. Really.. thank you for starting this up. This site is something that is needed on the web, someone with some originality.

  19. In todays news reporting clever journalists work their own slant into a story. Bloggers use it promote their works and many just use it for fun or to stay in touch with friends far away.

  20. Unquestionably believe that which you stated. Your favorite reason appeared to be on the internet the easiest thing to be aware of. I say to you, I definitely get annoyed while people consider worries that they just do not know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people could take a signal. Will probably be back to get more. Thanks

  21. I and also my guys were actually going through the great secrets on your web site and so at once came up with a terrible feeling I never expressed respect to the site owner for those techniques. My ladies had been warmed to read through all of them and already have in actuality been taking pleasure in these things. Appreciate your truly being really considerate and then for figuring out these kinds of superior things most people are really desperate to be aware of. My personal sincere regret for not expressing appreciation to you earlier.

  22. Greetings, There’s no doubt that your website could possibly be having browser compatibility issues. Whenever I take a look at your site in Safari, it looks fine however, if opening in Internet Explorer, it has some overlapping issues. I just wanted to give you a quick heads up! Besides that, great website.

  23. An intriguing discussion is definitely worth comment. I think that you ought to write more about this subject matter, it might not be a taboo matter but typically folks don’t discuss such subjects. To the next! Cheers.

  24. Thanks a lot for sharing this with all of us you actually know what you are talking about! Bookmarked. Kindly also visit my website =). We could have a link exchange agreement between us!

  25. Hi there! This post could not be written any better! Reading through this post reminds me of my good old room mate! He always kept chatting about this. I will forward this post to him. Pretty sure he will have a good read. Thanks for sharing!

  26. There are some fascinating deadlines on this article however I don’t know if I see all of them center to heart. There may be some validity but I will take maintain opinion till I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as effectively

  27. I blog quite often and I seriously thank you for your information. This great article has truly peaked my interest. I am going to take a note of your website and keep checking for new details about once a week. I subscribed to your RSS feed as well.

  28. I precisely needed to appreciate you all over again. I do not know the things that I would have implemented in the absence of these creative ideas contributed by you regarding this subject. Entirely was a frustrating case in my view, nevertheless being able to view the well-written mode you solved that took me to weep over happiness. I am just happier for the work as well as believe you know what an amazing job that you’re undertaking instructing most people with the aid of your website. More than likely you haven’t encountered any of us.

  29. Do you mind generally if I mention one or two of your current blogs as long as I deliver you acknowledgement coupled with sources returning to your web site? My blog site is within the corresponding topic as your own and my web site visitors would certainly make use of some of the help and advice that you provide on this site. Please make sure to inform me if it is okay for you. Cheers!

  30. Normally I do not read post on blogs, but I would like to say that this write-up very forced me to try and do so! Your writing style has been surprised me. Thanks, quite nice post.

  31. There are some interesting cut-off dates in this article but I don’t know if I see all of them center to heart. There is some validity but I’ll take maintain opinion till I look into it further. Good article , thanks and we would like extra! Added to FeedBurner as effectively

  32. I simply wanted to thank you a lot more for your amazing website you have developed here. It can be full of useful tips for those who are actually interested in this specific subject, primarily this very post. Your all so sweet in addition to thoughtful of others and reading the blog posts is a great delight in my opinion. And thats a generous present! Dan and I usually have enjoyment making use of your recommendations in what we need to do in the near future. Our checklist is a distance long and tips will certainly be put to excellent use.click here

  33. Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a little bit, but instead of that, this is wonderful blog. A great read. I will definitely be back.

  34. Today, while I was at work, my sister stole my apple ipad and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

  35. An impressive share! I’ve just forwarded this onto a co-worker who has been conducting a little homework on this. And he actually ordered me breakfast because I discovered it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanks for spending the time to discuss this subject here on your internet site.

  36. That is really fascinating, You are an excessively skilled blogger. I’ve joined your rss feed and sit up for in the hunt for more of your great post. Also, I have shared your web site in my social networks!

  37. This is the precise weblog for anybody who wants to find out about this topic. You realize a lot its nearly hard to argue with you (not that I actually would need…HaHa). You definitely put a new spin on a subject thats been written about for years. Nice stuff, just nice!

  38. Hey would you mind sharing which blog platform you’re working with? I’m planning to start my own blog in the near future but I’m having a difficult time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your layout seems different then most blogs and I’m looking for something completely unique. P.S Apologies for getting off-topic but I had to ask!

  39. I must say, as a lot as I enjoyed reading what you had to say, I couldnt help but lose interest after a while. Its as if you had a wonderful grasp on the subject matter, but you forgot to include your readers. Perhaps you should think about this from far more than one angle. Or maybe you shouldnt generalise so considerably. Its better if you think about what others may have to say instead of just going for a gut reaction to the subject. Think about adjusting your own believed process and giving others who may read this the benefit of the doubt.Jobs offered

  40. Fantastic goods from you, man. I have understand your stuff previous to and you are just extremely excellent. I actually like what you have acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still take care of to keep it sensible. I cant wait to read far more from you. This is really a tremendous website.

  41. Virtually all of the things you mention happens to be astonishingly precise and that makes me wonder the reason why I had not looked at this with this light before. Your article truly did turn the light on for me as far as this particular subject matter goes. Nevertheless there is one factor I am not really too cozy with so whilst I try to reconcile that with the actual main idea of the point, allow me observe what all the rest of your subscribers have to say.Very well done.

  42. It’s a pity you don’t have a donate button! I’d definitely donate to this excellent blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to fresh updates and will talk about this blog with my Facebook group. Chat soon!

  43. Unquestionably imagine that that you stated. Your favourite reason appeared to be on the net the simplest thing to take into accout of. I say to you, I definitely get irked even as other folks think about issues that they just don’t realize about. You managed to hit the nail upon the top and outlined out the whole thing without having side-effects , other folks could take a signal. Will likely be back to get more. Thanks

  44. I am really loving the theme/design of your web site. Do you ever run into any browser compatibility problems? A number of my blog visitors have complained about my blog not working correctly in Explorer but looks great in Firefox. Do you have any suggestions to help fix this issue?

  45. Greetings from Los angeles! I’m bored to tears at work so I decided to browse your blog on my iphone during lunch break. I love the info you provide here and can’t wait to take a look when I get home. I’m amazed at how fast your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, amazing site!

  46. What i don’t realize is actually how you are not really much more well-liked than you may be right now. You’re so intelligent. You realize therefore significantly relating to this subject, made me personally consider it from numerous varied angles. Its like men and women aren’t fascinated unless it is one thing to accomplish with Lady gaga! Your own stuffs great. Always maintain it up!

  47. you’re actually a excellent webmaster. The site loading pace is amazing. It seems that you’re doing any unique trick. Also, The contents are masterpiece. you’ve done a excellent activity on this matter!

  48. hey there and thanks for your information – I have certainly picked up something new from right here. I did alternatively experience several technical points the use of this website, as I skilled to reload the site lots of times prior to I could get it to load correctly. I were puzzling over in case your web hosting is OK? No longer that I am complaining, but slow loading instances occasions will often impact your placement in google and can damage your quality ranking if advertising and ***********|advertising|advertising|advertising and *********** with Adwords. Anyway I’m adding this RSS to my e-mail and could look out for a lot more of your respective intriguing content. Make sure you update this once more soon..

  49. Hmm it appears like your website ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to the whole thing. Do you have any tips for newbie blog writers? I’d definitely appreciate it.

  50. Youre so cool! I dont suppose Ive learn anything like this before. So good to find any individual with some authentic ideas on this subject. realy thanks for starting this up. this web site is one thing that’s needed on the net, someone with a little bit originality. useful job for bringing one thing new to the internet!

  51. An impressive share! I’ve just forwarded this onto a co-worker who had been doing a little research on this. And he in fact ordered me lunch simply because I found it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanx for spending time to talk about this topic here on your web page.

  52. I together with my friends came going through the excellent tricks from your web page while the sudden I got a horrible feeling I never thanked the web blog owner for those techniques. All the women had been absolutely very interested to see all of them and have very much been making the most of them. Appreciate your really being considerably considerate as well as for considering this sort of incredibly good themes millions of individuals are really eager to discover. My very own sincere apologies for not expressing appreciation to earlier.

  53. Can I just say what a comfort to discover someone who truly knows what they’re talking about over the internet. You actually realize how to bring an issue to light and make it important. A lot more people really need to look at this and understand this side of your story. It’s surprising you’re not more popular since you definitely have the gift.

댓글 남기기