sql选择题_SQL选择

sql选择题

SQL or Structured Query Language is all about storing, retrieving and manipulating data in the database. The most important aspect of SQL is retrieval of data from database. SQL Select statement is used to retrieve data from tables or views.

SQL或结构化查询语言都是关于在数据库中存储，检索和处理数据的。 SQL的最重要方面是从数据库中检索数据。 SQL Select语句用于从表或视图中检索数据。

SQL选择语句 (SQL Select Statement)

SQL SELECT statement enables us to retrieve the data from the database. The result of SQL Select query is returned in tabular format knows as result set.

SQL SELECT语句使我们能够从数据库中检索数据。 SQL Select查询的结果以表格格式返回，称为结果集。

SQL选择查询语法 (SQL Select Query Syntax)

SQL Select Query has two syntaxes – one for retrieval of data from particular columns and other for retrieval of all the data that is available in the table.

SQL Select查询具有两种语法-一种用于从特定列中检索数据，另一种用于检索表中可用的所有数据。

Retrieval of Data from Particular Column
Please find below the syntax for retrieval of data from particular column(s) of a table.

从特定列中检索数据
请在下面找到用于从表的特定列中检索数据的语法。

SELECT column_name(s) FROM table_name;

In the syntax above, the column_name should be specified between the SELECT and FROM keywords. The column_name that is specified in the query should exist in the table.

在以上语法中，应在SELECT和FROM关键字之间指定column_name。 表中应存在查询中指定的column_name。

Retrieval of Data from Complete Table

从完整表中检索数据

SELECT * FROM table_name;

In the syntax above, data from all the columns of the table is retrieved.

在上面的语法中，从表的所有列中检索数据。

Let’s us try to understand SQL SELECT query in more detail with some examples.

让我们尝试通过一些示例更详细地了解SQL SELECT查询。

SQL选择示例 (SQL Select Example)

Let us consider the following Employee table for all the scenarios that we will discuss as part of the example.

让我们考虑下面的Employee表，以作为示例的一部分我们将讨论的所有方案。

1. We want to retrieve name of all the employees who are younger than 25 years of age.

   SELECT EmpName FROM Employee WHERE EmpAge<25;

   Output:

   EmpName
   Amit
   Jason

   我们要检索所有25岁以下的员工的姓名。

   输出：

   EmpName
   阿米特
   杰森

2. We want to retrieve all the detail of employees who are younger than 25 years of age.

   SELECT * FROM Employee WHERE EmpAge<25;

   Output:

   EmpId	EmpName	EmpAge	EmpSalary
   1	Amit	22	2000
   3	Jason	24	2750

   我们要检索25岁以下员工的所有详细信息。

   输出：

   EmpId	EmpName	EmpAge	薪酬
   1个	阿米特	22	2000
   3	杰森	24	2750

3. We want to retrieve all the details of employees who are younger than employees having salary equal to 3000.

   SQL SELECT can also be used inside other select as a sub-query. Above requirement requires using select inside a sub query.

   SELECT * FROM Employee WHERE EmpAge<(SELECT EmpAge FROM Employee WHERE EmpSalary=3000);

   Output:
   

   SQL SELECT也可以在其他select中用作子查询。 以上要求要求在子查询中使用select。

   SELECT * FROM Employee WHERE EmpAge<(SELECT EmpAge FROM Employee WHERE EmpSalary=3000);

   输出：
   

Reference: Oracle Documentation

参考： Oracle文档

翻译自: https://www.journaldev.com/18262/sql-select

sql选择题