GitHub - vishnu-t-r/sql_functions_reference: 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)

vishnu-t-r / sql_functions_reference Public

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)

5 stars 0 forks Branches Tags Activity

Star

Notifications

1 Branch 0 Tags

About

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

Activity

5 stars

1 watching

0 forks

Report repository

Releases

No releases published

Packages

No packages published

Languages

TSQL 100.0%

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

About

Releases

Packages

Languages

Name		Name	Last commit message	Last commit date
Latest commit vishnu-t-r simple pivot function example Feb 25, 2025 7bee416 · Feb 25, 2025 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
74_set_operators.sql		74_set_operators.sql
75_join_multiple_tables_to_a_single_table_based_on_single_column (objectid_consider_objectname_in_join).sql		75_join_multiple_tables_to_a_single_table_based_on_single_column (objectid_consider_objectname_in_join).sql
76_json_functions_1(isjson, openjson, json_modify, json_value, json_query, for json)_part_1.sql		76_json_functions_1(isjson, openjson, json_modify, json_value, json_query, for json)_part_1.sql
77_parse_json_in_sql_openjson_part_2.sql		77_parse_json_in_sql_openjson_part_2.sql
78_parse_json_array_with_openjson_part_3.sql		78_parse_json_array_with_openjson_part_3.sql
79_open_json_file_using_openjson_&_openrowset_part_4.sql		79_open_json_file_using_openjson_&_openrowset_part_4.sql
7_subquery_usages.sql		7_subquery_usages.sql
80_parse_json_from_a_file_&_creae_a_table_part_5.sql		80_parse_json_from_a_file_&_creae_a_table_part_5.sql
81_parse_json_with_multi_cross_apply(json array and json object together)_part_6.sql		81_parse_json_with_multi_cross_apply(json array and json object together)_part_6.sql
82_date_and_time_functions_part_1.sql		82_date_and_time_functions_part_1.sql
83_fun_that_return_date_and_time_parts_part_2.sql		83_fun_that_return_date_and_time_parts_part_2.sql
84_fun_return_date_and_time_from_parts_part_3.sql		84_fun_return_date_and_time_from_parts_part_3.sql
85_modify_difference_validate_date_time_part_4.sql		85_modify_difference_validate_date_time_part_4.sql
86_generate_a_series_of_number_(recursive cte).sql		86_generate_a_series_of_number_(recursive cte).sql
87_convert_string_to_date_using_cast_convert_trycast_tryconvert.sql		87_convert_string_to_date_using_cast_convert_trycast_tryconvert.sql
88_row_number_rank_dense_rank_ntile.sql		88_row_number_rank_dense_rank_ntile.sql
89_cross_apply_application_create_new_column_with_range_of_values.sql		89_cross_apply_application_create_new_column_with_range_of_values.sql
8_recursive_sql_using_cte.sql		8_recursive_sql_using_cte.sql
90_avoid_divide_by_zero_error_2_methods.sql		90_avoid_divide_by_zero_error_2_methods.sql
91_er_diagrams.sql		91_er_diagrams.sql
92_delete_foreign_key_constraints_and_drop_table.sql		92_delete_foreign_key_constraints_and_drop_table.sql
93_insert_update_delete_in_a_single_merge_statement.sql		93_insert_update_delete_in_a_single_merge_statement.sql
94_value_clause_(insert-select-merge) 3 use case.sql		94_value_clause_(insert-select-merge) 3 use case.sql
95_delete_identity_constraint_from_a_column.sql		95_delete_identity_constraint_from_a_column.sql
96_delete_duplicate_data_from_parent(master)_table-4 methods.sql		96_delete_duplicate_data_from_parent(master)_table-4 methods.sql
97_all_constraints_added_when_creating_a_table.sql		97_all_constraints_added_when_creating_a_table.sql
98_inbuild_stored_procedure_to_get_view_script.sql		98_inbuild_stored_procedure_to_get_view_script.sql
99_for json path_vs_for json auto.sql		99_for json path_vs_for json auto.sql
9_ungroup_a_given_data_recursion_logic.sql		9_ungroup_a_given_data_recursion_logic.sql
import_csv_table_data_to_database_table_directly.sql		import_csv_table_data_to_database_table_directly.sql

vishnu-t-r/sql_functions_reference

Folders and files

Latest commit

History

About

Topics

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages