Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
SQL Essentials: FLOOR Function Explained
Overview
FLOOR is a numeric function that returns the largest integer value less than or equal to the given number.
In simpler terms, imagine you're looking at a number line with all the whole numbers (0, 1, 2, 3, and so on). When you use the FLOOR function on a specific number, it points to the largest whole number that is smaller than or equal to that number.
For example, if you think of the number 3.5, the FLOOR function will take you back to 3. Now consider a number like 7.2; the FLOOR function will still return 7, because 7 is the largest whole number that is less than or equal to 7.2.
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!