How to display two counts using oracle databases?

by edmond_brakus , in category: Third Party Scripts , 2 months ago

How to display two counts using oracle databases?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lottie , 2 months ago

@edmond_brakus 

To display two counts using Oracle databases, you can use the following SQL query:

1
2
3
4
5
SELECT
  COUNT(column1) AS count1,
  COUNT(column2) AS count2
FROM
  your_table_name;


Replace column1 and column2 with the columns you want to count, and your_table_name with the name of your table.


This query will return two counts in separate columns under the aliases count1 and count2.