SELECT TIMESTAMPDIFF(YEAR, dob, CURDATE()) AS age FROM persons; This query will return the age in years. If you want to get the age in months or days, you should use MONTH or DAY instead of YEAR in TIMESTAMPDIFF function. To get the age in months:SELECT TIMESTAMPDIFF(MONTH, dob, CURDATE()) AS age FROM persons; To get the […]
The GROUP BY clause in a SELECT statement is used to group rows in a table based on one or more columns. This allows you to perform aggregate functions, such as SUM, COUNT, and AVG, on the grouped data. The syntax for using the GROUP BY clause is as follows: SELECT column1, aggregate_function(column2)FROM table_nameGROUP BY
How to use the GROUP BY and HAVING clauses in a SELECT statement? Read More »
Table: table_a id 1 1 1 4 5 Table: table_b id 1 1 2 3 6 SQL Code to create table and insert data USE sqlforbi; CREATE TABLE `table_a` ( `id` int NOT NULL ); CREATE TABLE `table_b` ( `id` int NOT NULL ); insert into table_a values (1); insert into table_a values (1); insert
SQL for BI – Joins in SQL Read More »
How to change text colour on click using JavaScript? Code: <head><title>Expert Coder</title></head><body><h2>How to create a Nested List?</h2><ul><li>Furniture<ul><li>Chairs</li><li>Desk</li><li>Sofa</li></ul></li><li>Office Supplies</li><li>Technology</li></ul></body></html>https://youtu.be/4G9Lhtu4zo8
How to create a nested list in HTML? Read More »
In this article, I will explain how to calculate percentage difference from the first column and when the first column is null then consider next available value in the same row. Formula % Difference = (Current Value – Previous Value)/Previous Value Step 1 Drag “Order Date” field to the filter shelf and choose current week.
How to write calculations to find the percentage difference in Tableau? Read More »
To calculate without referring dimensions present in the view, you can use Fixed level of detail calculations. Syntax:{ Fixed [Dimension field]: Agg_function([Measure Field]) } Example: {Fixed [Category]: SUM([Sales])} % of Total= SUM([Sales])/SUM({Fixed [Category]: SUM([Sales])})
Fixed LOD calculation to find Percent of Total in Tableau Read More »
Table: orderdetail item_id order_id product_id selling_price discount quantity 1 10001 1 9500 250 1 2 10002 1 9500 400 2 3 10002 2 1900 50 5 4 10003 5 6800 100 1 5 10003 4 990 0 2 6 10003 3 4950 10 1 7 10003 2 1950 25 2 8 10004 3 4960 0
SQL for BI – Orderdetail table Read More »
Table: orders order_id cust_id order_date ship_date payment_mode created_date 10001 1 2022-01-15 22:15:00 2022-01-16 09:15:00 Credit Card 15/01/22 10002 1 2022-01-24 04:15:43 2022-01-26 15:00:15 Net Banking 24/01/22 10003 4 2022-01-30 08:15:32 2022-01-30 13:15:00 Cash on Delivery 30/01/22 10004 5 2022-02-13 21:20:00 2022-02-17 14:09:10 Credit Card 13/02/22 10005 3 2022-02-14 18:00:14 2022-02-14 18:10:10 Credit Card 14/02/22 SQL
SQL for BI – Orders table Read More »
Task 1: Download “Sample Superstore 2022 – Excel data” file from here 1. Connect to the data source 2. Change the name of field “Product name” to “Product Description” 3. Change the data role for the “Order Date” field to Date && Time
What is SQL? Acronym SQL stands for Structured Query Language used to communicate between you and the database. Data is stored in the database in the form of tables. SQL is used to Write data in a database Read (query) data stored in a database Update and insert new data Syntax for SQL depends on
