Finding maximum value of 3 different columns of a single record in SQL query

( select max(value)  from   (values (internal1),(internal2),(internal3)  )

as my(value)) as final

 

Here internal1,internal2,internal3 are columns of a table

Advertisements

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