我有一张桌子Table_1:
D1----D2
123----NULL
1a3----NULL
35s----NULL
tg45---NULL
如果我这样做了:
SELECT * FROM Table_1 A
RIGHT JOIN(
SELECT *
FROM Table_1 B
WHERE
SUBSTRING(B.D1,len(B.D1)-1,100) NOT LIKE '%[^0-9]%') C
ON A.D1=C.D1
WHERE CONVERT(INT,(SUBSTRING(A.D1,len(A.D1)-1,100)))<25;
我得到的结果是一
我有一个控制器动作:
Function SelectFloor(ByVal selectedBuilding As String) As PartialViewResult
If oneFloorBuildings.Contains(serializer.Deserialize(Of String)(selectedBuilding)) Then
Return RedirectToAction("SelectOfficeAddress", "LocationSelect")
End If
我有一个数据帧,如下所示 Category Value
A 10
B 22
A 2
C 30
B 23
B 4
C 8
C 24
A 9 我需要创建一个基于以下条件的标志列标志 If the values of Category A is greater than or equal 5 then Flag=1, else 0
If the values of Category B is greater than or equal