मुख्य क्वेरी में उपयोग हेतु अस्थायी रिजल्ट सेट बनाएँ।
Conditional logic
SELECT
todays_date,
temperature,
status,
CASE
WHEN temperature > 70 AND status NOT IN ('Rain', 'Wind') THEN 'Beach'
WHEN temperature BETWEEN 45 AND 70 AND status = 'Sun' THEN 'Sports'
WHEN temperature <= 32 OR status = 'Snow' THEN 'Skiing'
ELSE 'Stay In'
END AS activity
FROM weather;
Conditional logic को aggregation functions जैसी चीज़ों के साथ जोड़ा जा सकता है.
Subqueries
SELECT
month_num,
AVG(differential) AS avg_differential
MIN(differential) AS most_differential
FROM (
SELECT
month_num,
windchill - temperature AS differential
FROM weather
WHERE
season = 'Winter' AND
temperature < 32
)
GROUP BY month_num;
Common Table Expressions
WITH at_risk AS (
SELECT
student_id
course_name,
teacher_name,
grade
FROM student_courses
WHERE grade < 70 AND is_required
)
SELECT
students.student_name,
at_risk.*
FROM at_risk
JOIN students ON at_risk.student_id = students.id;
Common Table Expressions (CTE's) एक क्वेरी के परिणामों को अस्थायी रूप से स्टोर करती हैं, ताकि उन्हें आगे दूसरी क्वेरी उपयोग कर सके
$$
क्वेरियों को अधिक पठनीय, मॉड्यूलर बनाकर स्ट्रक्चर करें
Preparing Video For Download...
