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 |
What is datadir?
How do I remove a user from mysql?
What mysql means?
Which is better mysql or mssql?
What is the usage of ENUMs in MySQL?
Can we create table in stored procedure?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What can you do with mysql?
Why myisam is faster than innodb?
How do I disable mysql?
If you wish to encrypt the username and password using php, how will you do that?
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)