Question

急,SQL选择语句

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.pagecount
last = false
else
intpage = cint(page)
end if
end if
end if
if not rs.eof then
rs.AbsolutePage = intpage
end if
%>

Answer 1

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"棚前碧碰

Answer 2

select * from anli where Elite=True And Elite=False order by ID desc group by Elite=True,
Elite=False
就OK了数历！和亮给分吧薯棚搜

Answer 3

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

Answer 4

说明一下anli表的各字段