Sql

select (count(refinst)::decimal / (select count(*) from patients)::decimal) * 100  as "Formula" 
from patients;

PREVIOUS	NEXT

Code Example
Sql :: oracle tablespace usage
Sql :: oracle drop default value
Sql :: how-to-remove-mysql-root-password
Sql :: forcefully delete a row in mysql which has references
Sql :: sql join on a subquery
Sql :: sql pivot without aggregate
Sql :: sql distinct
Sql :: mysql insert rows to another database
Sql :: sql row having max
Sql :: Add a new column into table
Sql :: sql arithmetic operators
Sql :: rebuild index sql server
Sql :: select other columns with distinct
Sql :: date in mysql
Sql :: oracle drop type if exists
Sql :: Import zipped mysql dumps
Sql :: sql 2 way of select unique
Sql :: how to check default value of column in sql server
Sql :: coalesce function in sql server
Sql :: sqlite clear console
Sql :: oracle ora-00054 how to unlock
Sql :: postgresql find blocked query
Sql :: round .5 to 1 in sql server
Sql :: no suitable driver found for sqlite
Sql :: sql query order
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’.
Sql :: offset in postgresql example
Sql :: check constraint in ms sql
Sql :: compound trigger oracle
Sql :: what is top n result in sql