Monday, February 8, 2016


     
     
     
      
     
        
       
 
       
       
       
        
                   
        
         SELECT  Count(Sno) as NoOfAppsLTHr
         FROM  my_QRY_ITEMS
         WHERE  status=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime < 121
         AND    nydate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
                   
        
         SELECT  Count(Sno) as NoOfAppsMTHr
         FROM  my_QRY_ITEMS
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime > 120
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
          
        
        
        
        
       
       
       
     
            
               
               
               
               
               
               
           
 
           
 
          
         
       
    
       
       
         
                   
        
         SELECT  Count(Sno) as NoOfAppsLTHr
         FROM  my_QRY_ITEMS
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime < 121
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
                   
        
         SELECT  Count(Sno) as NoOfAppsMTHr
         FROM  xxx_QRY_xxx
         WHERE  myStatus=
         AND   AppComesFrom=
         AND   CustAccNo like 
         AND   myTime > 120
         AND    myDate between to_date('#NBetween1#','DD-MM-YYYY HH24:MI:ss') AND to_date('#NBetween2#','DD-MM-YYYY HH24:MI:ss')  
          

        
        
        
        
        
        
        
          
          
          
            
               
               
               
               
               
               
               
               
            
            
           
         
        
          
        
        
       
      
      
     
     
    
     
    
     
    
     
 

No comments:

Post a Comment