Skip to end of banner Go to start of banner

Implementer's SQL Guide

Skip to end of metadata

Created by Arun Paul, last modified on May 25, 2015

Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

To write custom reports, an implementer should be good with SQL statements.

Given below a set of common SQL clauses an implementer should learn to master custom reports.

SELECT
WHERE
INNER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
GROUP BY
ORDER BY
SUM
IF
DATEDIFF
DATEADD
CREATE VIEW

Some resources are given below:

No labels

The Bahmni documentation is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)