The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Does Vertica have a quotient function?

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

Comments

  • 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
  • That makes sense, thanks! How do I mark this question as [answered]?
  • Hi Laelsan,

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

    Regards,

    Bhawana

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.