SQL•SQL References

SQL ASC Keyword

Concept visual

SQL ASC Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ASC Keyword

Asc

The ASC

command is used to sort the data returned in ascending order. The following SQL statement selects all the columns from the "Customers" table, sorted by the "CustomerName" column:

Example

SELECT * FROM Customers
ORDER BY CustomerName ASC;

SQL ASC Keyword

Concept visual

SQL ASC Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

ASC Keyword

Asc

The ASC

command is used to sort the data returned in ascending order. The following SQL statement selects all the columns from the "Customers" table, sorted by the "CustomerName" column:

Example

SELECT * FROM Customers
ORDER BY CustomerName ASC;

SQL ASC Keyword

SQL ASC Keyword

ASC Keyword

Previous

Next

Asc

The ASC

Example

Previous

Next

SQL ASC Keyword

SQL ASC Keyword

ASC Keyword

Previous

Next

Asc

The ASC

Example

Previous

Next