Error at line 2, missing expression (help)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Error at line 2, missing expression (help)

Author

Topic

partnole
Starting Member

2 Posts

Posted - 2008-07-24 : 13:54:08

SELECT last_name, first_name ||'earns'||salary||'per month'||
FROM employees
ODER BY salary DESC;

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-24 : 13:56:41

Which database are you using?

E 12°55'05.25"
N 56°04'39.16"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-24 : 13:57:38

do you meant this?
SELECT last_name+ first_name +'earns'+cast(salary as varchar(10))+ 'per month'
FROM employees
ORDER BY salary DESC;

partnole
Starting Member

2 Posts

Posted - 2008-07-24 : 13:58:49

ORACLE
Using SQLPLUS

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-24 : 13:59:48

quote:
Originally posted by partnole

ORACLE
Using SQLPLUS

then you're in wrong forum .post it in some oracle forums to get oracle specific solution.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-24 : 14:26:21

Try www.dbforums.com

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-25 : 03:11:34

quote:
Originally posted by Peso

Try www.dbforums.com

E 12°55'05.25"
N 56°04'39.16"

I usually suggest www.orafaq.com

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-25 : 03:14:11

quote:
Originally posted by partnole

SELECT last_name, first_name ||'earns'||salary||'per month'||
FROM employees
ODER BY salary DESC;

You dont need last two pipes

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources