Calculation of derived field in sql

Posted by Matt on Stack Overflow See other posts from Stack Overflow or by Matt
Published on 2010-04-25T16:53:18Z Indexed on 2010/04/25 17:03 UTC
Read the original article Hit count: 189

Filed under:

Taking Sql this quarter and not having any luck with the following question:

  1. The height of players in feet (inches/12). Include their name. Hint: Calculation or derived field. Be sure to give the calculated field a column header.

We're learning the basic Select statment and didn't find any reference on how to make custom data at w3schools. I'm using Microsoft SQL server Management Express Here's my statment so far:

 select nameLast, nameFirst, height
 from Master
 where height    (I assume its something like 'Player_Height' = height/12)         
 order by nameLast, nameFirst, height

Thanks for the help

© Stack Overflow or respective owner

Related posts about sql