Skip to content

vishnu-t-r/sql_functions_reference

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

136 Commits
100_json_value()_vs_json_query().sql
100_json_value()_vs_json_query().sql
 
 
101_comparing_for json path()_and_for json auto()_practical_example.sql
101_comparing_for json path()_and_for json auto()_practical_example.sql
 
 
102_openjson()_in_detail.sql
102_openjson()_in_detail.sql
 
 
103_system_tables_and_views (default in-built tables).sql
103_system_tables_and_views (default in-built tables).sql
 
 
104_dynamically_changing_the_dimesion_for_aggregation(using a variable).sql
104_dynamically_changing_the_dimesion_for_aggregation(using a variable).sql
 
 
105_all_joins_and_union.sql
105_all_joins_and_union.sql
 
 
106_string_date_to_date_of_required_format.sql
106_string_date_to_date_of_required_format.sql
 
 
107_pivot_and_unpivot_functions.sql
107_pivot_and_unpivot_functions.sql
 
 
108_3 methods to delete duplicate data from master table.sql
108_3 methods to delete duplicate data from master table.sql
 
 
109_10 advanced concepts to know for advanced analytics.sql
109_10 advanced concepts to know for advanced analytics.sql
 
 
10_view_and_recursion_together_maxrecursion_syntax.sql
10_view_and_recursion_together_maxrecursion_syntax.sql
 
 
110_multiple_row_data_concatenated_into_single_row(string_agg).sql
110_multiple_row_data_concatenated_into_single_row(string_agg).sql
 
 
111_add a column if it does not exists already.sql
111_add a column if it does not exists already.sql
 
 
112_split concatenated string into separate columns (charindex parsename).sql
112_split concatenated string into separate columns (charindex parsename).sql
 
 
113_distinct records using group by.sql
113_distinct records using group by.sql
 
 
114_cross apply and outer apply (similar to inner join and outer join).sql
114_cross apply and outer apply (similar to inner join and outer join).sql
 
 
115_5 tips for better sql (part 1).sql
115_5 tips for better sql (part 1).sql
 
 
116_date and time data types.sql
116_date and time data types.sql
 
 
117_add or substract dates (dateadd and datediff).sql
117_add or substract dates (dateadd and datediff).sql
 
 
118_dateadd function question and answers.sql
118_dateadd function question and answers.sql
 
 
119_create a sequence of continuous dates (using recursive cte).sql
119_create a sequence of continuous dates (using recursive cte).sql
 
 
11_if_else_examples.sql
11_if_else_examples.sql
 
 
120_extract date parts without using date functions (using convert).sql
120_extract date parts without using date functions (using convert).sql
 
 
121_modify column data type (alter table alter column).sql
121_modify column data type (alter table alter column).sql
 
 
122_alter table statement (add-drop-modify-rename).sql
122_alter table statement (add-drop-modify-rename).sql
 
 
123_percent keyword.sql
123_percent keyword.sql
 
 
124_concept of sql joins with null and duplicate values.sql
124_concept of sql joins with null and duplicate values.sql
 
 
125_charindex to extract part of text.sql
125_charindex to extract part of text.sql
 
 
126_cube group by.sql
126_cube group by.sql
 
 
127_rollup in group by.sql
127_rollup in group by.sql
 
 
128_ranking window functions.sql
128_ranking window functions.sql
 
 
129_display all the tables in a database (4 methods).sql
129_display all the tables in a database (4 methods).sql
 
 
12_nested_if_else.sql
12_nested_if_else.sql
 
 
130_simple pivit function example.sql
130_simple pivit function example.sql
 
 
13_create_table_insert_data_simple.sql
13_create_table_insert_data_simple.sql
 
 
14_simple_fltering.sql
14_simple_fltering.sql
 
 
15_sum_min_max_avg_stdev_count.sql
15_sum_min_max_avg_stdev_count.sql
 
 
16_in_and_not_in_operator.sql
16_in_and_not_in_operator.sql
 
 
17_and_or_not_operator.sql
17_and_or_not_operator.sql
 
 
18_orderby_and_groupby.sql
18_orderby_and_groupby.sql
 
 
19_find_duplicate_records_using_count_having.sql
19_find_duplicate_records_using_count_having.sql
 
 
1_date_functions.sql
1_date_functions.sql
 
 
20_having_clause.sql
20_having_clause.sql
 
 
21_having_vs_where_clause.sql
21_having_vs_where_clause.sql
 
 
22_unique_vs_distinct.sql
22_unique_vs_distinct.sql
 
 
23_left(outer)_join_vs_right(outer)_join.sql
23_left(outer)_join_vs_right(outer)_join.sql
 
 
24_inner_join_vs_outer_join.sql
24_inner_join_vs_outer_join.sql
 
 
26_sorting_vs_filtering.sql
26_sorting_vs_filtering.sql
 
 
27_running_sum_vs_total_sum.sql
27_running_sum_vs_total_sum.sql
 
 
28_join_wth_exclusion.sql
28_join_wth_exclusion.sql
 
 
29_update_part_of_string_using_replace.sql
29_update_part_of_string_using_replace.sql
 
 
2_import_csv_table_data_to_database_table_directly.sql
2_import_csv_table_data_to_database_table_directly.sql
 
 
30_appending_data_in_sql.sql
30_appending_data_in_sql.sql
 
 
31_percentile_disc_vs_percentile_cont.sql
31_percentile_disc_vs_percentile_cont.sql
 
 
32_query_execution_order.sql
32_query_execution_order.sql
 
 
33_cross_join.sql
33_cross_join.sql
 
 
34_identify_reverse_pair_multiple_methods.sql
34_identify_reverse_pair_multiple_methods.sql
 
 
35_pivot_data_method_1.sql
35_pivot_data_method_1.sql
 
 
36_between_operator_on_number_text_dates.sql
36_between_operator_on_number_text_dates.sql
 
 
37_row_no_rank_dense_rank.sql
37_row_no_rank_dense_rank.sql
 
 
38_dynamic_sql_query.sql
38_dynamic_sql_query.sql
 
 
39_dynamic_sql_inside_stored_procedure.sql
39_dynamic_sql_inside_stored_procedure.sql
 
 
3_exists_operator_usage.sql
3_exists_operator_usage.sql
 
 
40_dynamic_sql_query_inside_stored_procedure_all_paramters_not_required.sql
40_dynamic_sql_query_inside_stored_procedure_all_paramters_not_required.sql
 
 
41_creating_temp_table_in_dynamic_sql.sql
41_creating_temp_table_in_dynamic_sql.sql
 
 
42_accumulating_values_into_a_variable.sql
42_accumulating_values_into_a_variable.sql
 
 
43_creating_output_parameters_in_stored_procedures.sql
43_creating_output_parameters_in_stored_procedures.sql
 
 
44_null_functions_in_sql.sql
44_null_functions_in_sql.sql
 
 
45_create_dml_trigger_to_concat_firstname_and_lastname.sql
45_create_dml_trigger_to_concat_firstname_and_lastname.sql
 
 
46_create_a_trigger_to_log_changes_to_a_table_insert_or_delete.sql
46_create_a_trigger_to_log_changes_to_a_table_insert_or_delete.sql
 
 
47_dynamic_joins.sql
47_dynamic_joins.sql
 
 
48_grouping_sets_clause.sql
48_grouping_sets_clause.sql
 
 
49_rollup_alternative_to_grouping_sets.sql
49_rollup_alternative_to_grouping_sets.sql
 
 
4_intersect_and_except_operators(set_operators).sql
4_intersect_and_except_operators(set_operators).sql
 
 
50_sub_queries_part_1_scalar_sub_queries.sql
50_sub_queries_part_1_scalar_sub_queries.sql
 
 
51_if_exists_in_sql.sql
51_if_exists_in_sql.sql
 
 
52_go_semicolon_statement_and_batch.sql
52_go_semicolon_statement_and_batch.sql
 
 
53_variance_var.sql
53_variance_var.sql
 
 
54_create_a_counter_for_a_looping_statement-while_loop.sql
54_create_a_counter_for_a_looping_statement-while_loop.sql
 
 
55_string_functions_part_1.sql
55_string_functions_part_1.sql
 
 
56_retrieving_random_records_from_table.sql
56_retrieving_random_records_from_table.sql
 
 
57_integer_to_decimal_conversion.sql
57_integer_to_decimal_conversion.sql
 
 
58_delete_truncate_drop_commands.sql
58_delete_truncate_drop_commands.sql
 
 
59_index_single-multi_column_index.sql
59_index_single-multi_column_index.sql
 
 
5_bitwise_operator_and_or.sql
5_bitwise_operator_and_or.sql
 
 
60_stored_procedure_to _insert_update_delete_table_records.sql
60_stored_procedure_to _insert_update_delete_table_records.sql
 
 
61_stored_procedure_for_insert_and_update_with_if_exists_else.sql
61_stored_procedure_for_insert_and_update_with_if_exists_else.sql
 
 
62_stored_procedure_for_insert_update_and_delete_with_if_exists_else.sql
62_stored_procedure_for_insert_update_and_delete_with_if_exists_else.sql
 
 
63_force_order(force order of joins).sql
63_force_order(force order of joins).sql
 
 
64_offset_fetch_function.sql
64_offset_fetch_function.sql
 
 
65_grouping_sets_rollup_cube.sql
65_grouping_sets_rollup_cube.sql
 
 
66_clustered_and_non-clustered_index.sql
66_clustered_and_non-clustered_index.sql
 
 
67_percent-rank_vs_cume-dist.sql
67_percent-rank_vs_cume-dist.sql
 
 
68_checking_distinct_count_multi_dimensions.sql
68_checking_distinct_count_multi_dimensions.sql
 
 
69_using_sum_and_case_when_together.sql
69_using_sum_and_case_when_together.sql
 
 
6_non_equi_join.sql
6_non_equi_join.sql
 
 
70_insert_record_with_merge.sql
70_insert_record_with_merge.sql
 
 
71_insert_update_target_table_with_merge.sql
71_insert_update_target_table_with_merge.sql
 
 
72_insert_update_delete_target_table_with_merge.sql
72_insert_update_delete_target_table_with_merge.sql
 
 
73_checking_actions_by_merge_statement_using_action.sql
73_checking_actions_by_merge_statement_using_action.sql
 
 

About

This repository contains intermediate to complex sql queries which explains sql concepts. This repository can be helpful when writing queries with complex concepts and can be considered for reference. (Most queries have DDL and DML command within for practise)

Topics

data-mining sql sql-query data-analysis complex-sql
Activity

Stars

5 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors

Languages