eSkillopedia
Open in Telegram
Telegram Channel: https://t.me/eSkillopedia eskillopedia LinkedIn: https://www.linkedin.com/company/eskillopedia/ Linkedin: https://www.linkedin.com/in/krishan-kumar-218719152/
Show more2 531
Subscribers
No data24 hours
No data7 days
No data30 days
Posts Archive
2 531
Analytical functions operate on a set of rows related to the current row and are often used for advanced analytics and reporting.
#### LAG() and LEAD():
Retrieve data from rows before or after the current row within a partition.
SELECT product_name, price, LAG(price) OVER (ORDER BY price) AS prev_price
FROM products;
#### FIRST_VALUE() and LAST_VALUE():
Get the first or last value within a partition.
SELECT department, employee_name, FIRST_VALUE(salary) OVER (PARTITION BY department ORDER BY hire_date) AS first_salary
FROM employees;
#### PERCENTILE_CONT():
Calculates a specified percentile within a group.
SELECT product_category, product_price, PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY product_price) OVER (PARTITION BY product_category) AS median_price
FROM products;
Analytical functions enable advanced statistical analysis and reporting.
2 531
Company Name : ZS Associates
Role : Decision Analytics Associate
Batch : 2024/2023/2022 passouts
Link : https://jobs.zs.com/jobs/19018
2 531
Company Name: Colgate
Post Name: Business Analyst
Salary: ₹5-8 LPA *
Experience: Freshers/Experience
Batch: 2024 and before
Job Location: Mumbai
Last date to apply: Apply ASAP
✅Apply Link: https://jobs.colgate.com/job/Mumbai-Analyst-Sr_-Analyst-Business-Analyst-MH/1089946700/
