KeyRainie的专栏

下面试Oracle的分页，效率比传统的分页高，但是存在的缺点是，当查询最后一页时，效率跟传统的分页效率时一样的。select * from (select rownum rn, a.* from (select int_id from cell) a where rownum where rn >= (页数+1)Informix的分页使用：select skip m fir

OleDbConnection connection = new OleDbConnection("Provider=Ifxoledbc.2;User ID=informix;Password=informix;Data Source=niosdb@niosserver34;Persist Security Info=true;");                string sql = "

IfxConnection connection = new IfxConnection("Database=niosdb;Host=192.168.8.56;Server=niosserver34;Service=8001; UID=informix;Password=informix;");                string sql = "insert into tap_so_V

select longitude,latitude from cell group by longitude,latitude having count(*)>1