Default password has not been changed

The admin password is set to its default value, it is recommended that you change it immediately!

You can change this password by logging in, navigating to My -> Account -> Password.

Current admin login:
   Username:"[email protected]"
   Password:"2Tight2Wiki@"

Order By

Table of Contents


Overview
Order by allows you to sort a result-set (either ascending or descending) by a given set of fields.

Notes on result limiters

When using a limiter such as TOP, the ORDER BY is executed before the limiter.

Example
round-pushpin Returns the Word records ordered ascending by Text.
SELECT
    Id, Text, LanguageId
FROM
    WordList:Word
WHERE
    Text LIKE 'Summar%'
ORDER BY
    Text

round-pushpin Also returns the Word records ordered ascending by Text.
SELECT
    Id, Text, LanguageId
FROM
    WordList:Word
WHERE
    Text LIKE 'Summar%'
ORDER BY
    Text ASC

round-pushpin Returns the Word records ordered descending by Text.
SELECT
    Id, Text, LanguageId
FROM
    WordList:Word
WHERE
    Text LIKE 'Summar%'
ORDER BY
    Text DESC

round-pushpin Returns the Word records ordered ascending by LanguageId and descending by Text.
SELECT
    Id, Text, LanguageId
FROM
    WordList:Word
WHERE
    Text LIKE 'Summar%'
ORDER BY
    LanguageId ASC,
    Text DESC


See also

Related