sql - count by on window function -

-

I created it that executes this query: 

 select  " E-mail". * ("Sender_contact_id" command over "sender_contact_id" by "email" .id, sender_contact_id, sender_user_id, rank () by DESC "sent_at"), like "contact_rnk", more than rank (by "sender_user_id" order Partition "sent_at" by DESC) from "email" to "user_rnk" ("folder" = 'inbox')) "e" inner join "email" ("email". "Id" = "e". " Id ") Where (DESC sent by contact_rnk = 1 or user_rnk = 1 and folder = 'inbox') order;   
 The point of the query is to return only 1 row for each contact or user, who has sent an email.  
 What's missing from the query that is the number of emails sent for each partition user or contact.  
 I can do it with many questions and can be involved in the end, eg. In the form of main (as select blbah, etc.)  
 , as cnt_users (select counting (sender_user_id) joining the inner main etc.), (select count (sender_contact_id) ) Joining the inner main etc.) cnt_contacts selection main. *, Contents etc. Is it possible to include count in first query without using  group ?   
 
 
 Rows can be counted without any  GROUP BY  each partition The trick is to use proper framing.  
 For example, the query can be modified as follows: ..  
  Select "email" *, from e * (select "email" .id, sender_contact_id, sender_user_id, number ("w1") as "contact_rnk", count ( *) More than (the last and infinite w1 ROWS between the limitless ones) as CONTACT_COUNT, rank () OV ER (W2) like "user_rnk", count (*) "email" should be included internally at email_participants EP. id = ep.email_id Where (folder = 'inbox') is more than USER_COUNT (the last and the limitless of the limitless, between the following W2 ROWS) and user_id = 220 (sent_at DESC by sender_contact_id order PARTITION) In the form of email JOIN (emails.id = e.id) on e-interiors as window w1, w2 (by sender_user_id order, by PARTITION sent_at DESC) where ((contact_rnk = 1 or user_rnk = 1) and folder = ' Inbox ') should be sent_at by command DESC   
 then  e.contact_count  and  e.user_count  each different  sender_contact_id  And  sender_user_id . Message is calculated for

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more