Skip to main content
Unix & Linux

Return to Answer

edited body
Source Link
Nainita
Nainita
  • 3k
  • 13
  • 36
  • 53

sql> select count (*) as fdr_data from fdr_data where datum like (select sysdate -1 from dual);

Output:

fdr_data

479808

fdr_data    
-------- 
899019

sql> select count (*) as fdr_data from fdr_data where datum like (select sysdate -1 from dual);

Output:

fdr_data

479808

sql> select count (*) as fdr_data from fdr_data where datum like (select sysdate -1 from dual);

Output:

fdr_data    
-------- 
899019
Source Link
Nainita
Nainita
  • 3k
  • 13
  • 36
  • 53

sql> select count (*) as fdr_data from fdr_data where datum like (select sysdate -1 from dual);

Output:

fdr_data

479808