Overview SQL in Analysis cells allows you to analyze and manipulate data within Log Workspaces. This documentation covers the SQL support available in Log Workspaces and includes:
Syntax The following SQL syntax is supported:
Syntax Description Example SELECT (DISTINCT)Retrieves rows from a database, with DISTINCT filtering out duplicate records.
Copy
SELECT DISTINCT customer_id
FROM orders JOINCombines rows from two or more tables based on a related column between them.
Copy
SELECT orders . order_id , customers . customer_name
FROM orders
JOIN customers
ON orders . customer_id = customers . customer_id GROUP BYGroups rows that have the same values in specified columns into summary rows.
Copy
SELECT product_id , SUM ( quantity )
FROM sales
GROUP BY product_id WHERELIKE filters on strings for pattern matching.Filters records that meet a specified condition.
Copy
SELECT *
FROM employees
WHERE department = 'Sales' AND name LIKE 'J%' CASEProvides conditional logic to return different values based on specified conditions.
Copy
SELECT order_id ,
CASE
WHEN quantity > 10 THEN 'Bulk Order'
ELSE 'Standard Order'
END AS order_type
FROM orders Arithmetic Operations Performs basic calculations using operators like +, -, *, /.
Copy
SELECT price , tax , ( price * tax ) AS total_cost
FROM products
Functions The following SQL functions are supported:
Function Return Type Description min(variable v)typeof v Returns the smallest value in a set of data. max(variable v)typeof v Returns the maximum value across all input values. count(any a)numeric Returns the number of input values that are not null. sum(numeric n)numeric Returns the summation across all input values. avg(numeric n)numeric Returns the average value (arithmetic mean) across all input values. ceil(numeric n)numeric Returns the value rounded up to the nearest integer. floor(numeric n)numeric Returns the value rounded down to the nearest integer. round(numeric n)numeric Returns the value rounded to the nearest integer. lower(string s)string Returns the string as lowercase. upper(string s)string Returns the string as uppercase. abs(numeric n)numeric Returns the absolute value. coalesce(args a)typeof first non-null a OR null Returns the first non-null value or null if all are null.
MIN
Copy
SELECT MIN ( response_time ) AS min_response_time
FROM logs
WHERE status_code = 200 MAX
Copy
SELECT MAX ( response_time ) AS max_response_time
FROM logs
WHERE status_code = 200 COUNT
Copy
SELECT COUNT ( request_id ) AS total_requests
FROM logs
WHERE status_code = 200 SUM
Copy
SELECT SUM ( bytes_transferred ) AS total_bytes
FROM logs
GROUP BY service_name AVG
Copy
SELECT AVG ( response_time )
AS avg_response_time
FROM logs
WHERE status_code = 200
GROUP BY service_name CEIL
Copy
SELECT CEIL ( price ) AS rounded_price
FROM products FLOOR
Copy
SELECT FLOOR ( price ) AS floored_price
FROM products ROUND
Copy
SELECT ROUND ( price ) AS rounded_price
FROM products LOWER
Copy
SELECT LOWER ( customer_name ) AS lowercase_name
FROM customers UPPER
Copy
SELECT UPPER ( customer_name ) AS uppercase_name
FROM customers ABS
Copy
SELECT ABS ( balance ) AS absolute_balance
FROM accounts COALESCE
Copy
SELECT COALESCE ( phone_number , email ) AS contact_info
FROM users Further reading Additional helpful documentation, links, and articles:
