What is the output of: SELECT 5 / 2 in most SQL databases using integer division?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What is the output of: SELECT 5 / 2 in most SQL databases using integer division?

Key points

  • Integer division in SQL truncates the decimal part
  • The result is always an integer
  • Be cautious of rounding errors when using division in SQL

Ready to go further?

Start full exam Practice more questions

Related questions