 |
| |
ขอเทคนิคการดึงข้อมูล แบบ Max ของข้อมูลเท่ากับค่าที่ต้องการอะครับ |
| |
 |
|
|
 |
 |
|
select sum(id_tb1) as _sum from Table2 where id_tb2 = 1 'กรณี coiling
|
 |
 |
 |
 |
| Date :
2018-03-13 19:56:08 |
By :
lamaka.tor |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
select count(name) , name
from tb1 inner join tb2
on tb1.id = tb2.id where name = 'Coiling'
group by name
|
ประวัติการแก้ไข
2018-03-13 22:13:56
| |
|
|
| |
| Date :
2018-03-13 22:12:13 |
By :
adminliver |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (SQL)
DECLARE @PODT TABLE (PK1 INT, PartName NVARCHAR(100))
DECLARE @ISDT TABLE (PK2 INT, PK1 INT)
INSERT INTO @PODT VALUES (1, N'ไก่งาม'), (2, N'เพราะขน'), (3, N'คนงามเพราะหอย')
INSERT INTO @ISDT VALUES (1, 1), (1, 9), (2, 1), (2, 2), (2, 3), (3, 1), (3, 2), (4, 1), (5, 1)
SELECT ISDT.*, PODT.*, ISNULL(PODT.PartName, 'หอยเน่า') AS PartNameSex FROM (
SELECT PK2, MAX(PK1) AS PK1
FROM @ISDT GROUP BY PK2
) ISDT
LEFT JOIN @PODT PODT on PODT.PK1 = ISDT.PK1
ORDER BY PK2 ASC
|
| |
|
|
| |
| Date :
2018-03-14 02:15:22 |
By :
หน้าฮี |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (VB.NET)
<HttpPost>
<Route("api/JavaServlet/PostOTH_H")>
Public Function PostOTH_H(ByVal req As JDT_Model.DataTableAjaxPostModel) As IHttpActionResult
'Dim curPageIndex As Integer = (req.start / req.length) + 1
'Dim searchValue = req.search.value
'Dim sortCol = req.order
'OFFSET @PageSize * (@PageNumber - 1) ROWS
'FETCH NEXT @PageSize ROWS ONLY;
'If sortCol.Count > 0 Then
'Dim getInfo1 = sortCol(0).column
'Dim getInfo2 = sortCol(0).dir
'End If
Dim dt = msrOTH_H.PostListInfo(req.start, req.length, req.search.value, req.sortCol)
Dim xData As New List(Of JDT_DataHeading)
dt.Skip(req.start).Take(req.length).ToList().ForEach(Sub(r)
xData.Add(New JDT_DataHeading() With {.JDT_Col01 = r.RECEIVE_NO,
.JDT_Col02 = r.DATE_RECEIVE,
.JDT_Col03 = r.Info1,
.JDT_Col04 = r.INVOICE_NO,
.JDT_Col05 = r.INVOICE_DATE,
.JDT_Col06 = r.Info2,
.JDT_Col07 = r.RCV_TYPE,
.JDT_Col08 = r.RECORD_NUMBER
})
End Sub)
Return Ok(New With {
.xyz = xData,
.error = "",
.recordsTotal = msrOTH_H.CountRows(),
.recordsFiltered = dt.Count
})
End Function
|
| |
|
|
| |
| Date :
2018-03-14 02:28:32 |
By :
หน้าฮี |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ลองแบบนี้ดูครับ
select t1.id_tb_2,t2.name
from
(select id_tb_2, max(id_tb_1) as id_tb_1 from table2) t1
left join table1 t2 on t1.id_tb_1=t2.id_tb_1
order by t1.id_tb_2
|
| |
|
|
| |
| Date :
2018-03-14 09:58:58 |
By :
fonfire |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
 Quote:เห็นเหมือนกัน แต่คิดต่างกัน
Code (SQL)
DECLARE @PODT TABLE (PK1 INT, PartName NVARCHAR(100))
DECLARE @ISDT TABLE (PK2 INT, PK1 INT)
INSERT INTO @PODT VALUES (1, N'ไก่งาม'), (2, N'เพราะขน'), (3, N'คนงามเพราะหอย')
INSERT INTO @ISDT VALUES (1, 1), (1, 2), (2, 1), (2, 2), (2, 3), (3, 1), (3, 2), (4, 1), (5, 1)
SELECT ISDT.PK2, PODT.PartName FROM (
SELECT PK2, MAX(PK1) AS PK1
FROM @ISDT GROUP BY PK2
) ISDT
LEFT JOIN @PODT PODT on PODT.PK1 = ISDT.PK1
WHERE PartName = N'ไก่งาม' --????? ทำไมต้องมีเอ็น PartName = 'ไก่งาม'
--ORDER BY PK2 ASC
+55555
|
| |
|
|
| |
| Date :
2018-03-14 10:19:38 |
By :
หน้าฮี |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
