Таблиця: current_dept_emp

Назад
Структура таблиці
Поле Тип Null Ключ За замовчуванням Додатково
emp_no int NO None
dept_no char(4) NO None
from_date date YES None
to_date date YES None
Дані таблиці (перші 100 рядків)
emp_no dept_no from_date to_date
10001 d005 1986-06-26 9999-01-01
10002 d007 1996-08-03 9999-01-01
10003 d004 1995-12-03 9999-01-01
10004 d004 1986-12-01 9999-01-01
10005 d003 1989-09-12 9999-01-01
10006 d005 1990-08-05 9999-01-01
10007 d008 1989-02-10 9999-01-01
10008 d005 1998-03-11 2000-07-31
10009 d006 1985-02-18 9999-01-01
10010 d006 2000-06-26 9999-01-01
10011 d009 1990-01-22 1996-11-09
10012 d005 1992-12-18 9999-01-01
10013 d003 1985-10-20 9999-01-01
10014 d005 1993-12-29 9999-01-01
10015 d008 1992-09-19 1993-08-22
10016 d007 1998-02-11 9999-01-01
10017 d001 1993-08-03 9999-01-01
10018 d004 1992-07-29 9999-01-01
10019 d008 1999-04-30 9999-01-01
10020 d004 1997-12-30 9999-01-01
10021 d005 1988-02-10 2002-07-15
10022 d005 1999-09-03 9999-01-01
10023 d005 1999-09-27 9999-01-01
10024 d004 1998-06-14 9999-01-01
10025 d005 1987-08-17 1997-10-15
10026 d004 1995-03-20 9999-01-01
10027 d005 1995-04-02 9999-01-01
10028 d005 1991-10-22 1998-04-06
10029 d006 1999-07-08 9999-01-01
10030 d004 1994-02-17 9999-01-01
10031 d005 1991-09-01 9999-01-01
10032 d004 1990-06-20 9999-01-01
10033 d006 1987-03-18 1993-03-24
10034 d007 1995-04-12 1999-10-31
10035 d004 1988-09-05 9999-01-01
10036 d003 1992-04-28 9999-01-01
10037 d005 1990-12-05 9999-01-01
10038 d009 1989-09-20 9999-01-01
10039 d003 1988-01-19 9999-01-01
10040 d008 2002-01-22 9999-01-01
10041 d007 1989-11-12 9999-01-01
10042 d002 1993-03-21 2000-08-10
10043 d005 1990-10-20 9999-01-01
10044 d004 1994-05-21 9999-01-01
10045 d004 1996-11-16 9999-01-01
10046 d008 1992-06-20 9999-01-01
10047 d004 1989-03-31 9999-01-01
10048 d005 1985-02-24 1987-01-27
10049 d009 1992-05-04 9999-01-01
10050 d007 1992-11-05 9999-01-01
10051 d004 1992-10-15 9999-01-01
10052 d008 1997-01-31 9999-01-01
10053 d007 1994-11-13 9999-01-01
10054 d003 1995-07-29 9999-01-01
10055 d001 1992-04-27 1995-07-22
10056 d005 1990-02-01 9999-01-01
10057 d005 1992-01-15 9999-01-01
10058 d001 1988-04-25 9999-01-01
10059 d002 1991-06-26 9999-01-01
10060 d009 1992-11-11 9999-01-01
10061 d007 1989-12-02 9999-01-01
10062 d005 1991-08-30 9999-01-01
10063 d004 1989-04-08 9999-01-01
10064 d008 1985-11-20 1992-03-02
10065 d005 1998-05-24 9999-01-01
10066 d005 1986-02-26 9999-01-01
10067 d006 1987-03-04 9999-01-01
10068 d007 1987-08-07 9999-01-01
10069 d004 1992-06-14 9999-01-01
10070 d008 1995-10-18 9999-01-01
10071 d003 1995-08-05 9999-01-01
10072 d005 1989-05-21 9999-01-01
10073 d006 1998-02-02 1998-02-22
10074 d005 1990-08-13 9999-01-01
10075 d005 1988-05-17 2001-01-15
10076 d005 1996-07-15 9999-01-01
10077 d003 1994-12-23 9999-01-01
10078 d005 1994-09-29 9999-01-01
10079 d005 1995-12-13 9999-01-01
10080 d003 1997-07-09 9999-01-01
10081 d004 1986-10-30 9999-01-01
10082 d008 1990-01-03 1990-01-15
10083 d004 1987-03-31 9999-01-01
10084 d004 1995-12-15 9999-01-01
10085 d004 1994-04-09 9999-01-01
10086 d003 1992-02-19 9999-01-01
10087 d007 1997-05-08 2001-01-09
10088 d009 1992-03-21 9999-01-01
10089 d007 1989-01-10 9999-01-01
10090 d005 1986-03-14 1999-05-07
10091 d005 1992-11-18 9999-01-01
10092 d005 1996-04-22 9999-01-01
10093 d007 1997-06-08 9999-01-01
10094 d008 1987-04-18 1997-11-08
10095 d007 1994-03-10 9999-01-01
10096 d004 1999-01-23 9999-01-01
10097 d008 1990-09-15 9999-01-01
10098 d009 1989-06-29 1992-12-11
10099 d007 1988-10-18 9999-01-01
10100 d003 1987-09-21 9999-01-01

Показано записів: 100 (максимум 100)

SQL запити для таблиці current_dept_emp
SELECT всіх даних
Виконати
INSERT новий запис
UPDATE запис
DELETE запис