Functions in dbwql

Numeric functions

Function name Description
add Adds a number to a base value
sub Substracts a number from a base value
div Diveds a number
mult Multiplies a number
abs Returns the absolute value of a number
until Return all numbers from a base number until an end number
round Rounds a number to a specified precision

Aggregate functions

Function name Description
groupby Groups a set on some value(s)
count Counts the number of rows
sum Sums all values in a set
avg Computes the average of set
max Finds the max value in a set
min Finds the minimum value in a set
orderby Orders a set

String functions

Function name Description
upper Converts a string to uppercase
lower Converts a string to lowercase
trim Strips empty spaces from the beginning and end of a string
concat Concats a number of strings
capitalize Capitalizes a string
mkstring Makes a string from a set
replace Replaces all occurences of string A with string B in a string C

Set functions

Function name Description
distinct Removes duplicates from a set of values
union The union of two sets
intersect The intersection of two sets

Generic functions

Function name Description
todate Converts a value to datestring


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment