急,SQL选择语句

来源：百度知道编辑：UC知道时间：2024/05/28 09:18:04

sql="select * from anli where Elite=True And Elite=False order by ID desc"

现要是想要Elite=True 时案例先显示推荐的,再接下来显示不推荐的

不知道如何操作,求助高人!!!!!!!!
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from anli where Elite=True order by ID desc"
rs.PageSize = 8
i=0
rs.CursorLocation = 3
rs.open sql,conn,1,3
if rs.bof and rs.eof then
response.Write("暂时没有客户名录!")
else
pre = true
last = true
page = trim(Request.QueryString("page"))
if len(page) = 0 then
intpage = 1
pre = false
else
if cint(page) =< 1 then
intpage = 1
pre = false
else
if cint(page) >= rs.pagecount then
intpage = rs.pa

sql="select * from anli where Elite=True or Elite=False order by Elite,ID desc"
或
sql="select * from anli where Elite=True or Elite=False order by Elite asc,ID desc"

select * from anli where Elite=True And Elite=False order by ID desc group by Elite=True,
Elite=False
就OK了！给分吧

select * from anli where Elite=True And Elite=False order by ID desc group by Elite=True, Elite=False
///Elite=True And Elite=False，这个是什么？还是应该Elite=True OR Elite=False

说明一下anli表的各字段

sql 选择语句问题急问SQL语句() SQL语句问题~~急！！！！ sql查询语句(急..) SQL语句问题，急，！一条SQL语句,急! 一条SQL语句,急!!! 急SQL语句 sum sql语句急！！急求一个SQL语句