SQL References

• ALTER TABLE

  Changing the basic structure of a table field names, sizes, data types, etc. ...

• AND

  Verify that a query returns a result only if both conditions are true.

• AS

  Alias. Rename a bird the name of a field extracted from a query to use only in

• AVG

  Returns the average of the values ​​of a field.

• BETWEEN

  Try searching for values ​​between two values ​​of the same type.

• CONSTRAINT

  Preserves data integrity by establishing limits on the values ​​you can enter in a record

• COUNT

  Returns an integer indicating the number of records found.

• CREATE INDEX

  List one or more fields in a table in order to facilitate and enhance the criteria

• CREATE TABLE

  Create a new table by specifying the field names, sizes and types of data.

• CREATE VIEW

  Create a view on a database, or a virtual table from which you can only draw

• <<
• 1
• 2
• 3
• 4
• 5
• >>