By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

ALIAS error

P: 1
hi iam running this simple query using table,column aliases
SELECT T1.student S1,SUM(T1.mark)"TOTAL MARKS" FROM ALLMARKS03 T1
GROUP BY T1.student
where T1 table alias s1 column alias,ALLMARKS03 is table name
ERROR: parser: parse error at or near "S1" at character 18
if i dont use column aliases just table aliases then fine otherwise above error
could u tell me where the error is
thanks in advance
Jan 6 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
You have a bad syntax, and error message you have indicates it.
Try to use one of the two examples below.
Expand|Select|Wrap|Line Numbers
  1. SELECT T1.student,  SUM(T1.mark) as "TOTAL MARKS" FROM ALLMARKS03 T1 
  2.  
  3. SELECT T1.student,  SUM(T1.mark) as S1 FROM ALLMARKS03 T1 
  4.  
Jan 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.