sql-server基礎(chǔ)查詢練習(附答案)-免費閱讀
【正文】 4列出從事SALES（銷售）工作的雇員的姓名，假定不知道銷售部的部門編號SELECT enameFROM empWHERE deptno = ( SELECT deptno FROM dept WHERE dname = 39。, 39。1顯示包含A的所有雇員的姓名及A在姓名字段中的位置SELECT ENAME , CHARINDEX(39。R39。MANAGER39。)。SALES39。NEW YORK39。, 39。FORD39。 INSERT INTO EMP VALUES (7900, 39。, 1500, 0, 30)。2001111739。, 7566,39。MANAGER39。, 39。MARTIN39。 INSERT INTO EMP VALUES (7566, 39。, 1600, 300, 30)。2000121739。IsFullTextInstalled39。test39。, FILENAME = N39。, 39。SALESMAN39。, 7698,39。20014239。,1250, 1400, 30)。 INSERT INTO EMP VALUES (7782, 39。scott39。, 39。SALESMAN39。, 7788,39。200131239。,3000, NULL, 20)。 INSERT INTO DEPT VALUES (10, 39。DALLAS39。OPERATIONS39。 AND deptno = 10 ) OR ( job = 39。, 39。R39。A39。smith39。SCOTT39。MANAGER39。%A%39。39。 AND DEPTNO = 20 ) OR ( JOB NOT IN ( 39。找出傭金高于薪金的雇員SELECT *FROM empWHERE m sal找出傭金高于薪金60%的雇員SELECT *FROM empWHERE m sal * 找出部門10中所有經(jīng)理和部門20中的所有辦事員的詳細資料SELECT *FROM empWHERE ( job = 39。)。RESEARCH39。2002012339。, 7566,39。CLERK39。, 39。TURNER39。 INSERT INTO EMP VALUES (7839, 39。, 2450, NULL, 10)。20015139。, 7698,39。MANAGER39。, 39。allen39。endGOALTER DATABASE [test] SET ANSI_NULL_DEFAULT OFF GOALTER DATABASE [test] SET ANSI_NULLS OFF GOALTER DATABASE [test] SET ANSI_PADDING OFF GOALTER DATABASE [test] SET ANSI_WARNINGS OFF GOALTER DATABASE [test] SET ARITHABORT OFF GOALTER DATABASE [test] SET AUTO_CLOSE OFF GOALTER DATABASE [test] SET AUTO_CREATE_STATISTICS ON GOALTER DATABASE [test] SET AUTO_SHRINK OFF GOALTER DATABASE [test] SET AUTO_UPDATE_STATISTICS ON GOALTER DATABASE [test] SET CURSOR_CLOSE_ON_COMMIT OFF GOALTER DATABASE [test] SET CURSOR_DEFAULT GLOBAL GOALTER DATABASE [test] SET CONCAT_NULL_YIELDS_NULL OFF GOALTER DATABASE [test] SET NUMERIC_ROUNDABORT OFF GOALTER DATABASE [test] SET QUOTED_IDENTIFIER OFF GOALTER DATABASE [test] SET RECURSIVE_TRIGGERS OFF GOALTER DATABASE [test] SET DISAB
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1