| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2010-04-21 : 14:52:46
|
| Is there a way to use alias names for columns as arguments for a function. example select assign, score, point, fn_lettergrade(score/point), sum(score) as totscore, sum(point) as totpoint, fn_lettergrade(totscore/totpoint).....It gave me an error I got the same error on trying to include an alias in a where clausesarah |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2010-04-21 : 21:35:43
|
| Thanks I will try itsarah |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-04-22 : 02:30:24
|
| or use the expression itselfselect assign, score, point, fn_lettergrade(score/point), sum(score) as totscore, sum(point) as totpoint, fn_lettergrade(sum(score) /sum(point)).....MadhivananFailing to plan is Planning to fail |
|
|
|
Asken
Starting Member
38 Posts |
Posted - 2010-04-22 : 03:17:00
|
quote:
Originally posted by madhivanan
or use the expression itselfselect assign, score, point, fn_lettergrade(score/point), sum(score) as totscore, sum(point) as totpoint, fn_lettergrade(sum(score) /sum(point))
Yeah, I'd go for that as well...
Reporting & Analysis SpecialistHelping others helps me get better... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
alias as function argument or in where clause