SQL FunctionsNumeric FunctionsFLOOROn this pageFLOORRounds the number down.SyntaxFLOOR( <x> )ExamplesSELECT FLOOR(1.23);┌─────────────┐│ floor(1.23) │├─────────────┤│ 1 │└─────────────┘