Question of the month April 2016 – What is the result of select $ _5a?

Can you guess the output of this query without actually running it?

SELECT $ _5a

The output is one of the following

1  invalid pseudocolumn "$ _5a".
2 _5a
3 Incorrect syntax near _5a
4 0.0

Advertisements

2 thoughts on “Question of the month April 2016 – What is the result of select $ _5a?

  1. Hi Madhivanan,

    As in your previous sessions you have explained the nature of Empty String for Non Character Datatype.
    By considering that,the $ _5a gives 0.00 result.
    Because $ indicates the Money datatype and it’s empty string implicit conversion results it to 0.00 and _5a is the column name/alias for it.

    Thank You.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s