How to display two counts using oracle databases?

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

How to display two counts using oracle databases?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by lottie , 6 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.

Related Threads:

How to connect more than two databases in codeigniter?
How to join between two databases in codeigniter?
How to update two tables using single procedure in oracle?
How to run two oracle instances in oracle 10g?
How to merge two tables in oracle?
How to display a description of a table in oracle sql?