I have one table named FDR_DATA. There are following fields present in the table. Fields are: B1_NAME, B2_NAME, B3_NAME, ELEMENT, DATUM, WERT. Now I want to query the total number of data in this table and following output will generate.
sql> select count (*) from fdr_data where datum like (select sysdate -1 from dual);
(It only shows the number of counts) But I want to print the datum (date) field beside the count.
How to write down the query to get the output like this way?
I have tried,
sql> select DATUM, count (*) from fdr_data where datum like (select sysdate -1 from dual)
But couldnot get the desired output.