Options

Does Vertica have a quotient function?

LaelsanLaelsan
in General Discussion
Quotient is the number of times a divisor goes into the dividend. Does Vertica have a function to do this?

Comments

  • Options
    BhawanaBhawana
    Hi,

    No we do not have that  funtion but you can try as:

    trader1849=> select trunc(11/3)::int;
    trunc
    -------
    3
    (1 row)

    trader1849=> select trunc(8/3)::int;
    trunc
    -------
    2
    (1 row)


    Regards,

    Bhawana
  • Options
    LaelsanLaelsan
    That makes sense, thanks! How do I mark this question as [answered]?
  • Options
    BhawanaBhawana
    Hi Laelsan,

    Thank you for the update, I will mark this as "answered".

    Regards,

    Bhawana

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...