access数据库8个经典实例

网站编辑2023-05-12 14:34:07475

以下是一个简单的SQLServer2005 8.0 Server 实例:

```sql CREATE TABLE s1.s2 as SET user (SERVER user, SYSTEM, LIMIT MAX, TRUNC(INDEX_EXTERNAL_SUPPLIES)AS SET User_ID = IDENTIFIED_MULTI_REGISTER);

CREATE TABLE s1.s3 as SET user_id INTEGER, (SERVER user, SYSTEM, LIMIT MAX, TRUNC(INDEX_EXTERNAL_SUPPLIES)AS SET User_id = IDENTIFIED_MULTI_REGISTER);

CREATE TABLE s3.s4 as SET user_id INTEGER, (SERVER user, SYSTEM, LIMIT MAX, TRUNC(INDEX_EXTERNAL_SUPPLIES)AS SET User_id = IDENTIFIED_MULTI_REGISTER); ```

该实例包含四个表:s1、s2、s3和s4,分别代表用户的用户ID和密码。

以下是一个简单的SQL查询:

```sql SELECT user_id, COUNT(*) AS total_amount FROM s1 WHERE user_id IN (INDEX_EXTERNAL_SUPPLIES) AND total_amount > 1; ```

该查询将返回每个用户的总金额,其中用户ID是唯一的标识符。