If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table?
Answers were Sorted based on User's Feedback
Answer / amith
999.99 to -99.99. Note that with the negative number the
minus sign is considered one of the digits.
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / rajesh kumar
minimum: -999.99
maximum: +999.99
It takes M+2 bytes to store. Here M is 5 and two extra byte
for storing sign & decimal.
| Is This Answer Correct ? | 5 Yes | 3 No |
Where is mysql password stored?
What is orm in mysql?
How to run a sql statement?
What is 1nf 2nf 3nf?
What is the command line end user interface - mysql?
how to find max salary from the database
Explain advantages of InnoDB over MyISAM?
How to delete a table.
What is difference between mysql_connect and mysql_pconnect?
How does mysql store dates?
What is unique key in mysql?
How do you concatenate strings in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)