想.涉.經

......神啊救救我吧！3天沒睡覺拉～

被系統搞到快要瘋掉了....資料被綁定，只能抓最後一筆，資料又見鬼的要跳三張表才能撈到資料......偶偵速無語問蒼天阿！

還好有SQL陪在你身邊...

資料表：DailyValues 

抓取欄位：Id

排序欄位：Date

//案怎抓取下一筆

string strSQL = "select top 1 * from (select Id,Email,Date,";
strSQL += "row_number() over(order by Date desc) as rownum";
strSQL += "from DailyValues WHERE Email='這是MAIL') myData";
strSQL += "where rownum < (";
strSQL += "select rownum from (select Id,Email,Date,";
strSQL += "row_number() over(order by Date desc) as rownum";
strSQL += "from DailyValues WHERE Email='這是MAIL') myData";
strSQL += "where Id='這是ID";
strSQL += ")";
strSQL += "order by rownum desc";

string strSQL = "select top 1 * from (select Id,Email,Date,row_number() over(order by Date desc) as rownum from DailyValues WHERE Email='這是MAIL') myData where rownum < (select rownum from (select Id,Email,Date,row_number() over(order by Date desc) as rownum from DailyValues WHERE Email='這是MAIL') myData where Id='這是ID') order by rownum desc";            //整理過的

//案怎抓取上一筆

string strSQL = "select top 1 * from (select Id,Email,Date,";
strSQL += "row_number() over(order by Date DESC) as rownum";
strSQL += "from DailyValues WHERE Email='這是MAIL') myData";
strSQL += "where rownum > (";
strSQL += "select rownum from (select Id,Email,Date,";
strSQL += "row_number() over(order by Date DESC) as rownum";
strSQL += "from DailyValues WHERE Email=' 這是MAIL') myData";
strSQL += "where Id='這是ID";
strSQL += ")";

string strSQL = "select top 1 * from (select Id,Email,Date,row_number() over(order by Date DESC) as rownum from DailyValues WHERE Email='這是MAIL') myData where rownum > (select rownum from (select Id,Email,Date,row_number() over(order by Date DESC) as rownum from DailyValues WHERE Email=' 這是MAIL') myData where Id='這是ID')                    //整理過的

//自己拉

記一下，郎老阿！不記會忘掉.........P.S:如果有問題就不要分段，直接修正為單一段SQL語法！