1. Home
  2. Program

Program

  • GROUP BY command in SQLGROUP BY command in SQL
    The GROUP BY clause in SQL is used in conjunction with the SELECT statement to sort data uniformly into groups.
  • DISTINCT keyword in SQLDISTINCT keyword in SQL
    The DISTINCT keyword in SQL is used in conjunction with the SELECT statement to remove all duplicate records and retrieve only records.
  • Sort results in SQLSort results in SQL
    To sort data in SQL, we use the ORDER BY clause.
  • Constraints in SQLConstraints in SQL
    Constraint is the rule applied on the data columns of a table.
  • The clause to combine JOIN data in SQLThe clause to combine JOIN data in SQL
    In SQL, the JOIN clause is used to combine records from two or more tables in a Database using common values ​​from each table.
  • INNER JOIN in SQLINNER JOIN in SQL
    INNER JOIN in SQL is the most important and often used JOIN type.
  • LEFT JOIN in SQLLEFT JOIN in SQL
    The LEFT JOIN in SQL is the type of JOIN that returns all records from the left table and matching records from the right table.
  • RIGHT JOIN in SQLRIGHT JOIN in SQL
    RIGHT JOIN in SQL is a type of JOIN that returns all records from the RIGHT side table and matching records from the LEFT side table.
  • FULL JOIN in SQLFULL JOIN in SQL
    FULL JOIN in SQL returns all records in the left table and the table must combine and fill in that NULL values ​​for values ​​do not match.
  • SELF JOIN in SQLSELF JOIN in SQL
    Each Join operation must have two tables, but there are cases where you have to perform JOIN on the same table, but you can call this JOIN operation SELF JOIN.
  • CARTESIAN JOIN in SQLCARTESIAN JOIN in SQL
    CARTESIAN JOIN in SQL returns the Cartesian product of record sets from two or more combined tables.
  • NULL value in SQLNULL value in SQL
    NULL in SQL is the term used to represent a missing value.
  • Create a temporary name using ALIAS in SQLCreate a temporary name using ALIAS in SQL
    SQL ALIAS is used to create a temporary name (called an alias) for a column or table.
  • Index (INDEX) in SQLIndex (INDEX) in SQL
    SQL index (INDEX) is a special lookup table that database search engines can use to quickly increase the time and performance of data retrieval.
  • ALTER TABLE statement in SQLALTER TABLE statement in SQL
    The ALTER TABLE statement in SQL is used to add, delete, and modify columns in an existing table.
  • Adjust performance in SQL Server: find slow queriesAdjust performance in SQL Server: find slow queries
    Adjusting SQL performance is a never-ending battle. This article will provide some tips for you to find slow SQL queries and perform performance tuning in SQL Server.
  • Use code to quickly create T-SQL scripts in SQL Operations Studio (preview)Use code to quickly create T-SQL scripts in SQL Operations Studio (preview)
    The code in SQL Operations Studio (preview) is the template that makes it easier to create databases and database objects.
  • Manage servers and databases with detailed utilities in SQL Operations Studio (preview)Manage servers and databases with detailed utilities in SQL Operations Studio (preview)
    Detailed utilities retrieve the Transact-SQL (T-SQL) queries you use to monitor servers and databases, then turn them into visual images.
  • UPDATE command in SQLUPDATE command in SQL
    UPDATE is the query used to edit existing records in the table. You can use the WHERE clause with the UPDATE statement to update selected rows, if not all rows in the table are
  • Boolean operators AND and OR in SQLBoolean operators AND and OR in SQL
    The AND and OR operators are used to combine multiple conditions to narrow the data in SQL statements. These two operators are called conjugate operators in SQL. AND and OR allow
Most viewed