select top 10 * from 档案 order by id not in (select top 10 * from 档案 order by id)
select top 10 * from 档案 not in (select top 10 * from 档案)说实在的我这句怎么就运行不了呀?
FROM 子句语法错误。
select top 10 * from 档案 order by id not in (select top 10 * from 档案 order by id) =========>>>>>>>> select top 10 * from 档案 order by id not in (select top 10 id from 档案 order by id)
我用了怎么就FROM 子句语法错误。问什么? Dim dr As System.Data.OleDb.OleDbDataReader, da As System.Data.OleDb.OleDbDataAdapter Dim co1 As System.Data.OleDb.OleDbConnection, comm As System.Data.OleDb.OleDbCommand Dim sql As String, ds As System.Data.DataSet sql = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("disp.aspx") co1 = New System.Data.OleDb.OleDbConnection() co1.ConnectionString = sql sql = "select top 10 * from 回复 not in (select top 10 * from 回复)" Label1.Text = sql da = New System.Data.OleDb.OleDbDataAdapter(sql, co1) ds = New System.Data.DataSet() da.Fill(ds) DataGrid1.DataSource = ds.Tables(0).DefaultView DataGrid1.DataBind()
select top 10 * from 档案 order by id not in (select top 10 * from 档案 order by id) =====>>> select top 20 * from 档案 where id not in (select top 10 id from 档案 order by id) order by id
=========>>>>>>>>
select top 10 * from 档案 order by id not in (select top 10 id from 档案 order by id)
Dim dr As System.Data.OleDb.OleDbDataReader, da As System.Data.OleDb.OleDbDataAdapter
Dim co1 As System.Data.OleDb.OleDbConnection, comm As System.Data.OleDb.OleDbCommand
Dim sql As String, ds As System.Data.DataSet
sql = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("disp.aspx")
co1 = New System.Data.OleDb.OleDbConnection()
co1.ConnectionString = sql
sql = "select top 10 * from 回复 not in (select top 10 * from 回复)"
Label1.Text = sql
da = New System.Data.OleDb.OleDbDataAdapter(sql, co1)
ds = New System.Data.DataSet()
da.Fill(ds)
DataGrid1.DataSource = ds.Tables(0).DefaultView
DataGrid1.DataBind()
=====>>>
select top 20 * from 档案
where id not in (select top 10 id from 档案 order by id)
order by id
小心别砸着
!