質問編集履歴
1
追記 Table
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,4 +7,14 @@
|
|
|
7
7
|
```SQL
|
|
8
8
|
delete from [tb_eSession] as tb where tb.[ID] Not In
|
|
9
9
|
(select TOP 1 ID from [tb_eSession] as tb1 where tb1.ses_uID = tb.ses_uID order by tb1.loginDate DESC)
|
|
10
|
+
```
|
|
11
|
+
|
|
12
|
+
追記 Table です
|
|
13
|
+
```SQL
|
|
14
|
+
create table [dbo].[tb_eSession] (
|
|
15
|
+
ID int identity not null
|
|
16
|
+
, [ses_uID] int
|
|
17
|
+
, [loginDate] datetime default getdate() not null
|
|
18
|
+
, primary key (ID)
|
|
19
|
+
);
|
|
10
20
|
```
|