What's wrong with this command in SQL plus?

Question

I want to count the number of employees

SQL> select count(ename) AS number of people, from emp;
select count(ename) AS number of people, from emp
                   *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected


SQL>

Here's my table

 SQL> select ename from emp;

 ENAME
 ----------
 KING
 BLAKE
 CLARK
 JONES
 MARTIN
 ALLEN
 TURNER
 JAMES
 WARD
 FORD
 SMITH

 ENAME
 ----------
 SCOTT
 ADAMS
 MILLER

 14 rows selected.

 SQL>

Bernard Dy · Accepted Answer · 2011-09-10 11:12:43Z

1

The comma after the "people" is probably what's causing the error.

You will also need to use a different alias for the count() column, either by removing the spaces or replacing them with underscores.

edited Sep 10, 2011 at 11:12

answered Sep 9, 2011 at 3:18

Bernard Dy

2,0122 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

Or using double quotes: as "Number Of People"

Joe · Accepted Answer · 2011-09-09 03:19:23Z

0

Remove the comma before the FROM clause. Also, you can't have spaces in field name, use underscores instead.

Also, it's good practice to capitalise keywords:

SELECT COUNT(ename) AS number_of_people FROM emp

answered Sep 9, 2011 at 3:19

Joe

15.8k4 gold badges52 silver badges84 bronze badges

Collectives™ on Stack Overflow

What's wrong with this command in SQL plus?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related