Get highest percentage value from a column based on value from another column in mySQL -


i have query percentages of different values in specific column:

select dma, count(*) / const.cnt *100 my_percent  full_db3 cross join  (select count(*) cnt full_db3) const group dma order my_percent desc limit 10;

step one: need amend gives me top 10 values in column dma based on value of column. example, if value in column gender "f", top 10 values in column dma. (which doesn't work, of course).

select dma, count(*) gender = 'female' / const.cnt *100 my_percent  full_db3 cross join  (select count(*) cnt full_db3) const group dma order my_percent desc limit 10;

the above throws error, should point across.

step 2 looping through columns , returning top 10 values in every column (not dma) give value of specific column (e.g., gender= 'female'). what's best way this?


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more