ROUND, CEIL, FLOOR in SQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the ROUND function do in SQL?

ROUND rounds a numeric value to the nearest integer or to a specified number of decimal places.

beginner

How does the CEIL function behave in SQL?

CEIL returns the smallest integer greater than or equal to the given number. It always rounds up.

beginner

What is the purpose of the FLOOR function in SQL?

FLOOR returns the largest integer less than or equal to the given number. It always rounds down.

beginner

How would you round the number 3.14159 to 2 decimal places using SQL?

Use ROUND(3.14159, 2) which returns 3.14.

beginner

If you apply CEIL to 4.2 and FLOOR to 4.8, what are the results?

CEIL(4.2) returns 5, FLOOR(4.8) returns 4.

What does ROUND(5.678, 1) return?

A 6

B 5.6

C 5.7

D 5

ROUND(5.678, 1) rounds to one decimal place, so it returns 5.7.

Which function always rounds a number up to the nearest integer?

A FLOOR

B CEIL

C TRUNC

D ROUND

CEIL always rounds up to the smallest integer greater than or equal to the number.

What is FLOOR(7.9)?

A 7

B 8

C 7.9

D 0

FLOOR returns the largest integer less than or equal to 7.9, which is 7.

Which function would you use to round 2.5 to the nearest integer?

A ROUND

B FLOOR

C CEIL

D ABS

ROUND rounds to the nearest integer, so ROUND(2.5) returns 3.

What does CEIL(-3.7) return?

A -4

B 3

C -3.7

D -3

CEIL(-3.7) returns the smallest integer greater than or equal to -3.7, which is -3.

Explain the difference between ROUND, CEIL, and FLOOR functions in SQL.

Think about how each function treats decimal numbers.

How would you use these functions to handle the number 5.3 in different ways?

Consider rounding up, down, or to nearest.