SQL Server Basics Tutorial: Select Learning

Select ' Column name ' from ' Table name ' SELECT List_name from table_name the ' table name ' Selection ' column name ' data SQL SELECT * FROM table_name ' all data from ' table name ' selection

SELECT ' column name ' from ' Table name ' WHERE ' condition '

Specify an alias to the data using as. This alias is used to use the count () function in an expression to calculate the number of elements in an array or the number of attributes in an object. SELECT CONCAT (*) as New_name

Join Joint Operation two table select ' Column name 1 ' column Name 2 ' from ' Table name 1 ' JOIN ' table name 2 ' on condition select A.symbol,a.sname from Securitycode a JOIN dayquote B on a. Full usage of SYMBOL =b.symbol sql--join (version 2)

Order by sort ASC Ascending, DESC descending select ' column name ' from ' Table name 1 ' ORDER by ' column name ' [ASC, DESC] Select List_name from table_name Orders by List_ Name

SELECT * FROM table LIMIT [offset,] rows | Rows Offset offset LIMIT Returns the specified number of records. LIMIT accepts one or two numeric parameters. parameter must be an integer constant. Given two parameters, the first parameter specifies the offset of the first row to return the record, and the second parameter specifies the maximum number of rows to be returned. The offset of the initial record line is 0 (instead of 1): SELECT * FROM table LIMIT 5, 10; Retrieve record line 6-15//To retrieve all row rows from an offset to the end of the recordset, you can specify that the second parameter is -1:select * from table LIMIT 95,-1; Retrieves the record row 96-last. If only one argument is given, it represents the maximum number of record rows returned: SELECT * from table LIMIT 5; Retrieves the first 5 rows//In other words, LIMIT n is equivalent to LIMIT 0,n.

Learn the SQL Insert Intoupdatedelete action statement with everyone:

Insert into table name values (value 1, value 2,....) inserts a value of 1, value 2, into the table name (column 1, column 2,...) by inserting a row of values in the table name. Values (value 1, value 2,....) specify column insertion data

UPDATE table Name set column name = ' value 2 ' where column name = ' value 1 ' Sets the original column value to value 1 in the table to the value 2

Delete from table name where column = ' value 1 ' delete Column Name value 1 row delete from table name where column = ' value 1 ' delete * FROM table name delete from table name remove all rows of table name