Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~152 People Reached
Favorite Forums
Favorite Tags
Member Avatar for tombatista

[CODE]Test = ''' SELECT /*+ INDEX (s_evt_act acc_temp_teste) */ todo_cd tipoemail, name subject, email_sndr_addr remetente, evt_stat_cd status, to_char(trunc(created), 'yyyy-mm-dd') data, COUNT(1) quantidade FROM sblprod.s_evt_act WHERE created >= TO_DATE(:DATAI, 'yyyy-mm-dd hh24:mi:ss') AND created <= TO_DATE(:DATAF, 'yyyy-mm-dd hh24:mi:ss') AND todo_cd IN ('Email - Entrada','Redução de Preço','Fax - Entrada','Email - Saída') GROUP BY …

Member Avatar for slate
0
152