SQL & PL/SQL

Hello,

i want the max, min and count of a table, which is grouped by a column

I need a combination of these two selects:

select
     max(COUNTRY_S) MAXVALUE,
     min(COUNTRY_S) MINVALUE
from
     tab_Country

select
     count(*)
from
     (select COUNTRY_TXT from tab_Country group by COUNTRY_TXT) ;

The result should be one row with the max and min value of the table and with the count of the grouped by table, not the max and min of each group! - i hope you understand my question?

Is this possible in one SQL-select?

Thank you very much

Best regards

Heidi