Member Avatar for Deeksh

how to round of the value after finding the avg in sql

  • 3 Contributors
  • 3 Replies
  • 153 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Deeksh
Member Avatar for IIM

there are many methods in MSSQL depending on your requirement(ceiling(),round() or floor())

  • ceiling() method :- Returns the smallest integer greater than, or equal to, the specified numeric expression.
  • round() method :- Returns a numeric value, rounded to the specified length or precision.
  • floor() method :- Returns the largest integer less than or equal to the specified numeric expression.

take a look at all mathematical functions avialable http://msdn.microsoft.com/en-us/library/ms177516.aspx

Member Avatar for Deeksh

thank u

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.