Files

100_json_value()_vs_json_query().sql
101_comparing_for json path()_and_for json auto()_practical_example.sql
102_openjson()_in_detail.sql
103_system_tables_and_views (default in-built tables).sql
104_dynamically_changing_the_dimesion_for_aggregation(using a variable).sql
105_all_joins_and_union.sql
106_string_date_to_date_of_required_format.sql
107_pivot_and_unpivot_functions.sql
108_3 methods to delete duplicate data from master table.sql
109_10 advanced concepts to know for advanced analytics.sql
10_view_and_recursion_together_maxrecursion_syntax.sql
110_multiple_row_data_concatenated_into_single_row(string_agg).sql
111_add a column if it does not exists already.sql
112_split concatenated string into separate columns (charindex parsename).sql
113_distinct records using group by.sql
114_cross apply and outer apply (similar to inner join and outer join).sql
115_5 tips for better sql (part 1).sql
116_date and time data types.sql
117_add or substract dates (dateadd and datediff).sql
118_dateadd function question and answers.sql
119_create a sequence of continuous dates (using recursive cte).sql
11_if_else_examples.sql
120_extract date parts without using date functions (using convert).sql
121_modify column data type (alter table alter column).sql
122_alter table statement (add-drop-modify-rename).sql
123_percent keyword.sql
124_concept of sql joins with null and duplicate values.sql
125_charindex to extract part of text.sql
126_cube group by.sql
127_rollup in group by.sql
128_ranking window functions.sql
129_display all the tables in a database (4 methods).sql
12_nested_if_else.sql
130_simple pivit function example.sql
13_create_table_insert_data_simple.sql
14_simple_fltering.sql
15_sum_min_max_avg_stdev_count.sql
16_in_and_not_in_operator.sql
17_and_or_not_operator.sql
18_orderby_and_groupby.sql
19_find_duplicate_records_using_count_having.sql
1_date_functions.sql
20_having_clause.sql
21_having_vs_where_clause.sql
22_unique_vs_distinct.sql
23_left(outer)_join_vs_right(outer)_join.sql
24_inner_join_vs_outer_join.sql
26_sorting_vs_filtering.sql
27_running_sum_vs_total_sum.sql
28_join_wth_exclusion.sql
29_update_part_of_string_using_replace.sql
2_import_csv_table_data_to_database_table_directly.sql
30_appending_data_in_sql.sql
31_percentile_disc_vs_percentile_cont.sql
32_query_execution_order.sql
33_cross_join.sql
34_identify_reverse_pair_multiple_methods.sql
35_pivot_data_method_1.sql
36_between_operator_on_number_text_dates.sql
37_row_no_rank_dense_rank.sql
38_dynamic_sql_query.sql
39_dynamic_sql_inside_stored_procedure.sql
3_exists_operator_usage.sql
40_dynamic_sql_query_inside_stored_procedure_all_paramters_not_required.sql
41_creating_temp_table_in_dynamic_sql.sql
42_accumulating_values_into_a_variable.sql
43_creating_output_parameters_in_stored_procedures.sql
44_null_functions_in_sql.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
47_dynamic_joins.sql
48_grouping_sets_clause.sql
49_rollup_alternative_to_grouping_sets.sql
4_intersect_and_except_operators(set_operators).sql
50_sub_queries_part_1_scalar_sub_queries.sql
51_if_exists_in_sql.sql
52_go_semicolon_statement_and_batch.sql
53_variance_var.sql
54_create_a_counter_for_a_looping_statement-while_loop.sql
55_string_functions_part_1.sql
56_retrieving_random_records_from_table.sql
57_integer_to_decimal_conversion.sql
58_delete_truncate_drop_commands.sql
59_index_single-multi_column_index.sql
5_bitwise_operator_and_or.sql
60_stored_procedure_to _insert_update_delete_table_records.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
63_force_order(force order of joins).sql
64_offset_fetch_function.sql
65_grouping_sets_rollup_cube.sql
66_clustered_and_non-clustered_index.sql
67_percent-rank_vs_cume-dist.sql
68_checking_distinct_count_multi_dimensions.sql
69_using_sum_and_case_when_together.sql
6_non_equi_join.sql
70_insert_record_with_merge.sql
71_insert_update_target_table_with_merge.sql
72_insert_update_delete_target_table_with_merge.sql
73_checking_actions_by_merge_statement_using_action.sql
74_set_operators.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
77_parse_json_in_sql_openjson_part_2.sql
78_parse_json_array_with_openjson_part_3.sql
79_open_json_file_using_openjson_&_openrowset_part_4.sql
7_subquery_usages.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
82_date_and_time_functions_part_1.sql
83_fun_that_return_date_and_time_parts_part_2.sql
84_fun_return_date_and_time_from_parts_part_3.sql
85_modify_difference_validate_date_time_part_4.sql
86_generate_a_series_of_number_(recursive cte).sql
87_convert_string_to_date_using_cast_convert_trycast_tryconvert.sql
88_row_number_rank_dense_rank_ntile.sql
89_cross_apply_application_create_new_column_with_range_of_values.sql
8_recursive_sql_using_cte.sql
90_avoid_divide_by_zero_error_2_methods.sql
91_er_diagrams.sql
92_delete_foreign_key_constraints_and_drop_table.sql
93_insert_update_delete_in_a_single_merge_statement.sql
94_value_clause_(insert-select-merge) 3 use case.sql
95_delete_identity_constraint_from_a_column.sql
96_delete_duplicate_data_from_parent(master)_table-4 methods.sql
97_all_constraints_added_when_creating_a_table.sql
98_inbuild_stored_procedure_to_get_view_script.sql
99_for json path_vs_for json auto.sql
9_ungroup_a_given_data_recursion_logic.sql
import_csv_table_data_to_database_table_directly.sql

16_in_and_not_in_operator.sql

in and not operator

Nov 8, 2022

662a778 · Nov 8, 2022