Interested to Buy Any Domain ? << Click Here >> for more details...
If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table?
- 2 Answers
- 7423 Views
- I also Faced
- E-Mail Answers
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 |
What can I do with mysql?
How to load data from a text file into a table?
What is a trigger? How you can create a trigger in mysql?
What is difference between group by and order by clause?
What is the diff. bwt. primary key and unique key?
Can mysql handle big data?
What is limit in mysql?
What is inner join in mysql?
How does mysql store data?
Is blocked because of many connection errors mysql?
Is postgresql better than mysql?
How do I change directories in mysql?
-
Oracle (3259) - 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)
