SQL Advanced

SQL Advanced

FREE

(4 stars)

(72)


Download for Android

10,000 - 50,000 downloads

Add this app to your lists
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 高度, star join inner sql, inner join ripetute sql, sql avanzato tutorial, sql select * from table, sql 結合.

Comments and ratings for SQL Advanced
  • (59 stars)

    by James Hood on 21/01/2014

    Very good app along with the other sql apps make learning sql very easy. Bug. Sql lite instead of like second column down on the app apart from that well done!

  • (59 stars)

    by mohamed Shad on 10/01/2014

    Testing on

  • (59 stars)

    by Ivan Jones on 05/12/2013

    Lots of typos

  • (59 stars)

    by Art on 10/11/2012

    There is absolutely no reason this app should ever track my GPS location.

  • (59 stars)

    by A Google User on 10/11/2012

    There is absolutely no reason this app should ever track my GPS location.

  • (59 stars)

    by BIG DOG on 02/11/2012

    ...nor do I see any reason it needs full internet access(I mean, do we *really* need ads in an app like this???)