Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
N
N
number12018-04-16 08:48:14
MySQL
number1, 2018-04-16 08:48:14

How to split subqueries?

There is a table . It is
necessary to count the number of records under two different conditions and divide the result of one subquery into another.
How to do this in mysql with one query?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
D
Dmitry Entelis, 2018-04-16
@number1 

select 
   (SELECT count(*) FROM `....` WHERE ...) / (SELECT count(*) FROM `...` WHERE ...) as rate

Similar questions
W
WebDev2016-06-10 11:27:59
Process running but not in htop? 4Reply
P
PEKTOP2014-05-15 16:47:54
Why did git pull start saving files as root? 7Reply
G
Gambik2012-08-07 00:24:51
Who tested the IN operator in MySQL? How fast is it and are there alternatives? 11Reply
A
Artyom2018-04-12 16:07:19
Python + MySql: Why is no data being added to the table? 1Reply
M
millwright2015-12-04 02:46:48
How to get the ID of a newly created row in MySQL? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question