-2

Can anyone please explain the difference between the datatypes decimal(1, 1) and numeric (1, 1) in SQL with an example?

Ellen Choi
  • 3
  • 1
  • 1
    In **SQL Server**, the types `decimal` and `numeric` are **equivalent** - no difference – marc_s Oct 23 '18 at 19:24
  • Which [DBMS](https://en.wikipedia.org/wiki/DBMS) product are you using? "SQL" is just a query language, not the name of a specific database product. Please add the tag for the database product you are using `postgresql`, `oracle`, `db2`, `sql-server`, ... –  Oct 23 '18 at 19:25
  • Welcome to SO. Please do at least 1 Google search prior to posting, especially if it is something as concrete as a definition of data types. – dfundako Oct 23 '18 at 19:25
  • Same thing, according to the ANSI/ISO SQL standard. – jarlh Oct 23 '18 at 19:49

1 Answers1

0

There is no difference, NUMERIC and DECIMAL are synonyms:Microsoft Docs

Igor Carvalho
  • 668
  • 5
  • 19