• Heather Florio
  • NEWBIE
  • 0 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
Hello. I'm working on the API and am trying to query the table named "Order" and also sort the results. I get an error because the word order is a reserved word in SQL. How do I work around this? I've tried brackets and backticks around the table name, but neither of those worked.

SELECT OrderNumber FROM Order limit 5 order by OrderNumber

How do I use the reserved word "order" as the table name?

Thank you!
Hello. I'm working on the API and am trying to query the table named "Order" and also sort the results. I get an error because the word order is a reserved word in SQL. How do I work around this? I've tried brackets and backticks around the table name, but neither of those worked.

SELECT OrderNumber FROM Order limit 5 order by OrderNumber

How do I use the reserved word "order" as the table name?

Thank you!