sql group by multiple row
SQL comma-separated row with Group By clause
Approximating commuting matrices by commuting diagonalizable matrices Suppose the matrices $A$ and $B$ commute. Do there exists sequences $A_n$ and $B_n$ of matrices such that   $A_n \rightarrow A$, $B_n \rightarrow B$.  Each $A_n$ is diagonalizable  and the same for each $B_n$.  For every $n$, $A_n$ commutes with $B_n$.    Moreover, it would be nice if the following property was additionally satisfied: if $A,B$ are real, then $A_n,B_n$ can be chosen to be real as well. I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:  Applepie Applesauce Crabapple Banana Mango   What I need is the count of all visible cells containing the word "Apple". Note that this should exclude the hidden (filtered out) cells. Now I have found out a formula:  `=SUMPRODUCT(SUBTOTAL(3,OFFSET(Sheet1!A:A,ROW(Sheet1!A:A)-MIN(ROW(Sheet1!A:A)),,1))*(Sheet1!A:A="&lt;Text to search&gt;"))`   However the problem with this one is this formula searches for the entire text. NOT just a part of it. How do I modify this formula to return count of cells containing "Apple" i.e. for this example it should return 3 as the result. Is the external micro SD card path the same for all devices? I am using a Samsung Tab 2.  There is a path: /mnt/external_sdcard/myfile. Here, I can save, read, or write my file to the external micro SD card.  I'm just wondering if this path is the same for all devices, or if it may be different. What is the "Bootable flag" option when installing a distro? Is the "bootable flag" needed in today's distributions? If not, then why is it still in the installers? What is it exactly? What is the purpose of old-school D&D class level limitations? When to use "have" and "have got" How can I set default value in ActiveRecord?  I see a post from Pratik that describes an ugly, complicated chunk of code:   class Item &lt; ActiveRecord::Base     def initialize_with_defaults(attrs = nil, &amp;block)     initialize_without_defaults(attrs) do       setter = lambda { |key, value| self.send("#{key.to_s}=", value) unless         !attrs.nil? &amp;&amp; attrs.keys.map(&amp;:to_s).include?(key.to_s) }       setter.call('scheduler_type', 'hotseat')       yield self if block_given?     end   end   alias_method_chain :initialize, :defaults end   I have seen the following examples googling around:    def initialize      super     self.status = ACTIVE unless self.status   end   and    def after_initialize      return unless new_record?     self.status = ACTIVE   end   I've also seen people put it in their migration, but I'd rather see it defined in the model code.  Is there a canonical way to set default value for fields in ActiveRecord model? How do I get an animated gif to work in WPF? What control type should I use - Image, MediaElement, etc.? Adjectives and nouns to describe an answer that doesn't answer the question? I've heard of the adjectives 'nonresponsive' or , but are they restricted to law^?     Collins Dictionary:  =       not responsive, not reacting to a stimulus   The definition above differs from the definitions of adjectives like 'equivocate,  evade' and nouns like , but these are negative and accusive; I prefer neutral connotation.  ^Only if you wish, please see: ,  by David Berg,  by Thomas A. Mauet. As a(n) noun vs as only On the street, temperatures at night are about -5 &deg;С and about 8 &deg;C during the day. In the apartment it is about 25 &deg;C. So, there is condensation on the windows and I don't want to wipe the windows every time.  How do I prevent condensation on the balcony windows? How to create an interactive bash script to collect arguments for a command in linux? I'm trying to create an interactive bash script where I can collect user input variables to be used as arguments in another command. Can someone provide me an example of this?  Currently i want to do:   what type of content you want to delete? what is the status?   then feed it into a mysql delete query command. I have several covariates in my calculation for a model, and not all of them are statistically significant.  Should I remove those that are not?  This question discusses the phenomenon, but does not answer my question:   There is nothing in the answer to that question that suggests that non-significant covariates be taken out, though, so right now I am inclined to believe that they should stay in.  Before even reading that answer, I was thinking the same since a covariate can still explain some of the variance (and thus help the model) without necessarily explaining an amount beyond some threshold (the significance threshold, which I see as not applicable to covariates).  There is another question somewhere on CV for which the answer seems to imply that covariates should be kept in regardless of significance, but it is not clear on that.  (I want to link to that question, but I was not able to track it down again just now.)  So...   Should covariates that do not show as statistically significant be kept in the calculation for the model?  (I have edited this question to clarify that covariates are never in the model output by the calculation anyway.)  To add complication, what if the covariates are statistically significant for some subsets of the data (subsets which have to be processed separately).  I would default to keeping such a covariate, otherwise either different models would have to be used or you would have a statistically significant covariate missing in one of the cases.  If you also have an answer for this split case, though, please mention it. Need help in the longtable with the figure High p-values for logistic regression variable that perfectly separates? I'm using R to run some logistic regression. My variables were continuous, but I used cut to bucket the data. Some particular buckets for these variables always result in dependent variable being equal to 1. As expcted, the coefficient estimate for this bucket is very high, but the p-value is also high. There are about ~90 observations in either these buckets, and around 800 total observations, so I don't think it's a problem of sample size. Also, this variable should not be related to other variables, which would naturally reduce their p-values.  Are there any other plausible explanations for the high p-value?  Example:  myData &lt;- read.csv("application.csv", header = TRUE) myData$FICO &lt;- cut(myData$FICO, c(0, 660, 680, 700, 720, 740, 780, Inf), right = FALSE) myData$CLTV &lt;- cut(myData$CLTV, c(0, 70, 80, 90, 95, 100, 125, Inf), right = FALSE) fit &lt;- glm(Denied ~ CLTV + FICO, data = myData, family=binomial())   Results are something like this:  Deviance Residuals:       Min        1Q    Median        3Q       Max   -1.53831  -0.77944  -0.62487   0.00027   2.09771    Coefficients:                 Estimate Std. Error z value Pr(&gt;|z|)     (Intercept)     -1.33630    0.23250  -5.747 9.06e-09 *** CLTV(70,80]     -0.54961    0.34864  -1.576 0.114930     CLTV(80,90]     -0.51413    0.31230  -1.646 0.099715 .   CLTV(90,95]     -0.74648    0.37221  -2.006 0.044904 *   CLTV(95,100]     0.38370    0.37709   1.018 0.308906     CLTV(100,125]   -0.01554    0.25187  -0.062 0.950792     CLTV(125,Inf]   18.49557  443.55550   0.042 0.966739     FICO[0,660)     19.64884 3956.18034   0.005 0.996037     FICO[660,680)    1.77008    0.47653   3.715 0.000204 *** FICO[680,700)    0.98575    0.30859   3.194 0.001402 **  FICO[700,720)    1.31767    0.27166   4.850 1.23e-06 *** FICO[720,740)    0.62720    0.29819   2.103 0.035434 *   FICO[740,780)    0.31605    0.23369   1.352 0.176236     --- Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1  (Dispersion parameter for binomial family taken to be 1)      Null deviance: 1037.43  on 810  degrees of freedom Residual deviance:  803.88  on 798  degrees of freedom AIC: 829.88  Number of Fisher Scoring iterations: 16   FICO in the range [0, 660) and CLTV in the range (125, Inf] indeed always results in Denial = 1, so their coefficients are very large, but why are they also "insignificant"? How to show ascii art at the top of the terminal when it's opened? I have a problem , i can't open synaptic >:(  root@dopeboy:~# synaptic No protocol specified ** (synaptic:6940): WARNING **: Could not open X display No protocol specified (synaptic:6940): Gtk-WARNING **: cannot open display: :1   I have try to Re-install it but is not working, any idea how to fix?! VPS Ubuntu 14.04 LTS. Why do some questions in question lists have a yellow background? On SO, when I'm scrolling through "questions" some have a yellow background.  Is this intuitive to everyone but me?  What is the yellow background trying to tell me about this particular question? I want to count the total number of files in particular directory that ends with ".mp4" extension.  I am getting following command:  ls -F |grep -v / | wc -l   It count all the files in particular directory, but I want the count of files that end with .mp4 extension.  Is there any Ubuntu command for that? Scenario: I have a custom button on a standard layout, which will call an apex class to do some validation on a record. If not validated, it needs to throw out some errors on that page. What are the best UX options to achieve this?  I am not too sure how to achieve this. Within a trigger, you can use the addError method to add the custom errors.  Can my Apex class reference the fields of a standard object? The ideal approach would be to do the following:  Contact.Email.addError('Please enter the right format here');   How can I achieve this via an apex class that the custom button will call?  What I have thought: Having a VF Page popup on the screen so that user can see all the errors, but that's not the best approach as UX is a big deal for this application  Thanks.