FREE DOWNLOAD

SQL Advanced

    • SEARCH TYPE
    SQL Advanced icon

    SQL Advanced

    by: Android mob 72 7.4

    7.4 Users
    rating
    FREE DOWNLOAD


    Screenshots

    Description

    SQL Advanced:

    SQL TOP: TOP is used to specify the number of rows to display in the result.

    SQL LIKE: LIKE is used in the WHERE clause to search for a pattern.

    SQL Wildcards: Wildcards are special characters that are used to perform special searches.

    SQL IN: IN to select multiple values ​​in a WHERE clause.

    SQL BETWEEN: BETWEEN is used in the WHERE clause to select values ​​from a range of data.

    SQL ALIAS: ALIAS is used to rename a table or column.

    SQL JOINS: JOIN can query data from 2 or more tables.

    SQL INNER JOIN: INNER JOIN is used to combine each row in a table with each row in another table.

    SQL LEFT JOIN: LEFT JOIN is used to combine the values ​​of the first table with the values ​​of the second table.

    SQL RIGHT JOIN: RIGHT JOIN is used to combine the values ​​of the first table with the values ​​of the second table.

    SQL FULL JOIN: FULL JOIN is used to combine the values ​​of the first table with the values ​​of the second table.

    SQL UNION: UNION is used to accumulate the results of two SELECT statements.

    SQL UNION ALL: SQL UNION ALL is used to accumulate the results of two SELECT statements, even rows will be repeated.

    SQL SELECT INTO: SELECT INTO is used to copy data from one table to another table.

    SQL CREATE DATABASE: CREATE DATABASE is used to create databases.

    SQL RESTRICTIONS: Restrictions are used to limit the data type of a column.

    SQL NOT NULL: NOT NULL is used to specify that a column does not accept NULL.

    SQL UNIQUE: UNIQUE is used to uniquely identify each row in a table

    UNIQUE SQL ALTER TABLE: ALTER TABLE to add UNIQUE UNIQUE to a column of a table, after being created.

    SQL PRIMARY KEY: PRIMARY KEY is used to uniquely identify each row in a table.

    SQL FOREIGN KEY: FOREIGN KEY is used to identify a column that is primary key in another table.

    Tags: sql 高度 , sql select * from table , sql 結合 , inner join ripetute sql , sql avanzato tutorial , star join inner sql

    Users review

    from 72 reviews

    "Great"

    7.4