Which three SQL statements would display the value 1890.55 as $1, 890.55?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Which three SQL statements would display the value 1890…
Which three SQL statements would display the value 1890.55 as $1, 890.55?
A, D, E
C is incorrect because you cannot mix up in one format of a number coma, dot with G and D. It needs to be or coma and dot or D and G. Not
coma and D, not G and dot etc.
A, D, E
0
0999
9990
Returns leading zeros.
Returns trailing zeros.
9
9999
Returns value with the specified number of digits with a leading space if positive or with a leading minus if negative. Leading zeros are blank, except for a zero value, which returns a zero for the integer part of the fixed-point number.