+ 1
Why am I getting a "missing expression" error?
I want to select the unique values of a column named Department and print the length of each value. Here is the query I wrote to do the above task: SELECT LENGTH(DISTINCT(DEPARTMENT)) FROM WORKER; But I'm getting a "missing expression" error while running it.
5 Réponses
+ 2
Try this...
SELECT LENGTH(DISTINCT DEPARTMENT) FROM WORKER;
+ 2
Anurag Mondal which programming language you are using to connect to SQL?
+ 1
Let me try this.. wait
+ 1
AKSHAY I'm not using any programming language..just running the query in the database gui frontend. oracle 10g
0
AKSHAY still not working..same error