Advanced SQL Queries - Learn by solving real life challenges

This page is an online version of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
This page allows you to read this book online, be updated with new solutions, and ask questions.

1. Detecting Empty Columns

2. Locating Empty Rows

3. Locating Duplicate Rows

4. Handling Percent (%) Values

5. Possible Combinations

6. Identifying Numerical Values - A

7. Identifying Numerical Values - B

8. Finding Middle Rows

9. Summarizing Digits

10. Lowest and Highest Values

11 . Character Occurrences - A

12. Character Occurrences - B

13. Extracting Substring from a String

14. Concatenating Values

15. Using the Pivot Operator

16. Pivot without Pivot

17. Pivoting Without Aggregation

18. Summarizing Values

19. Calculating Cumulative Sum

20. Cumulative Sum by Groups

21. Employees Attendance

22. Matching between Values

23. Using Unpivot

24. Using Pivot and Unpivot

25. Reverse Order of a String

26. List of Dates

27. The Fibonacci Sequence

28. GROUP BY over a range

29. Maximum Quantity

30. Highest Number of Repetitions

31. Combining Values – A

32. Combining Values – B

33. Splitting Text into Multiple Columns

34. Merging Fields

35. Splitting a Row into Multiple Fields

36. Date Ranges

37. Identifying Start and End Dates

38. Number of Products per Supplier

39. Comparing Values

40. Methods of Conditional Replacement

41. Splitting Fields over Multiple Columns

42. Locating Flights

43. Average Time Differences

44. Calculating the Rent

45. Calculating Monthly Salaries

46. Super Heroes

47. Cumulative Average

48. Calculating Product Sales

49. Total Sum of Sales

50. Defining Models

51. Sequential Numbers

52. Pairing Values

53. Products by Type

54. Calculating Date Difference

55. Splitting a Sentence

56. Extracting an Email Address

57. First and Last Value

58. Dynamic Pivot

59. Summing Up Values

60. ROLLUP and CUBE

61. Analyzing Survey Results

62. Cumulative Sum

63. Splitting an Amount of Money into Coins

64. Divide Fields into Groups

65. Last Record in Each Group

66. Region Hierarchy

67. Creating Pairs

68. Minimum Number of Missing Days

69. Inventory Stock Calculation

70. Displaying Matching Values

71. Maximum Value from Multiple Columns

72. Summarizing Values

73. Exchange Rates

74. Ticket Sales

75. Defining Valid Dates

76. Split Payments

77. Display of Repeating Values

78. Filling-in Empty Values

79. Running Balance

80. Finding Maximum Values

81. Horizontal Sorting

82. Locating Missing Ranges

83. Specifying Consecutive Months

84. Calculating Profit

85. Locating Start and End Values

86. Travel Routes

87. Activity Report

88. Sorting Values in Multiple Columns

89. Hotel Check-In & Check-Out

90. Customers Join Date

91. Locating Missing Values

92. Summarizing Values by Range

93. Work Progress

94. Time Differences

95. Calculating a Median

96. Identifying Groups

97. Candidate Interview Evaluation

98. Travel Destinations

99. Average Difference

100. Employees and Managers

ניתוח רווח והפסד

לפרטים נוספים

1. איתור עמודות עם ערכי Null

Employees Absence Report

Fetching Rows by Groups

Conditional Count

Comparing Grades

Hierarchical Queries

Continuous Values

Relational Division

Conditional Sum

Finding the Second Highest Value

Highest Date Per Group

Employees Absence Report

Employees Absence Report

[insert_php]
if ( is_user_logged_in() )
{
$current_user = wp_get_current_user();
echo ‘

Hi ‘ . substr($current_user->user_login,0,10) . ‘
‘;
echo ‘logout

‘;
}
else
{
if (ICL_LANGUAGE_CODE == “en”) {
echo ‘Login‘;}
else {
echo ‘Login‘;}
}
[/insert_php]

View on Facebook