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: 197
sql
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
© Stack Overflow or respective owner