mycommand = New SqlCommand("SELECT TOP 180 * FROM alltab WHERE groupno like '%" & Session("Groupno") & "%' order by id asc", MyConnection) 中的最后一条记录怎么取出来 用SQL语句
select * from( SELECT TOP 180 * FROM alltab WHERE groupno like '%" & Session("Groupno") & "%' order by id asc", MyConnection) where id not in ( SELECT TOP 179 id FROM alltab WHERE groupno like '%" & Session("Groupno") & "%' order by id asc", MyConnection)
mycommand = New SqlCommand("select top 1 * from alltab where id in(SELECT TOP 180 * id FROM alltab WHERE groupno like '%" & Session("Groupno") & "%')", MyConnection)
SELECT TOP 180 * FROM alltab WHERE groupno like '%" & Session("Groupno") & "%' order by id asc", MyConnection) where id not in (
SELECT TOP 179 id FROM alltab WHERE groupno like '%" & Session("Groupno") & "%' order by id asc", MyConnection)