Calculation of derived field in sql
- by Matt
Taking Sql this quarter and not having any luck with the following question:
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