Oracle Apex count and display number of entries in a column

Question

I have a table in Oracle Apex populated with contacts and their information. On the dashboard of my app, I'd like it to say how many contacts are in the database using the big list of values plug-in or something like that. I'm using the following code:

select contact_ID, count(*)
from
contacts
group by contact_id

However all I'm getting is the number of times each specific contact appears in the table (which is 1), instead of the total number of contacts. I understand what I did wrong in the code, but I'm not sure how to fix it.

For further information, the table columns are very basic, just 'Name', 'contact_id' (the primary key), 'Phone_Number', and so on. The table is called CONTACTS.

I'm also looking to eventually have the total number of organizations and comments on the dashboard as well.

Thanks!

romeuBraga · Accepted Answer · 2018-08-01 17:24:10Z

1

Try

SELECT
COUNT(mycolumn) AS d,
COUNT(mycolumn) AS r
FROM
mytable

answered Aug 1, 2018 at 17:24

romeuBraga

2,1651 gold badge10 silver badges23 bronze badges

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

3 Comments

Azat Ibrakov Over a year ago

why there are 2 identical COUNTs with different aliases?

romeuBraga Over a year ago

Unfortunately, this item in Oracle requires two columns

Littlefoot Over a year ago

First of them is a display value (alias = "d"), while the second one is a return value (alias = "r").

Gordon Linoff · Accepted Answer · 2018-08-01 15:29:33Z

0

I think you just want count(*):

select count(*)
from contacts;

Presumably, contactID is unique in a table called contacts.

answered Aug 1, 2018 at 15:29

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

1 Comment

Christopher Mariano Over a year ago

Unfortunately, this item in Oracle requires two columns and a group by function to be used.

Collectives™ on Stack Overflow

Oracle Apex count and display number of entries in a column

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related