Oracle basic query filtering sorting instance

Source: Internet
Author: User
Basic query: -- Query Information of all employees select * fromemp; -- set the row width setlinesize120; -- set the column width to the width of four digits

Basic query: -- Query Information of all employees select * from emp; -- set the row width set linesize 120; -- set the column width to the width of four digits

Basic query:

Note:

The SQL language is case insensitive.

SQL statements can be written in one or more rows.

Keywords cannot be abbreviated or branch

Each clause is generally written by a branch.

Use indentation to improve statement readability.

Filtering and sorting

Sorting rules:

It can be sorted by the column name in the select statement.

Sort by alias column name

It can be sorted by the sequential values of the column names in the select statement.

If you want to sort by multiple columns, the rule is to first sort by the first column, if the same, then sort by the second column; and so on

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.