怎么样让数据只显示前5行啊,,用SQL语句写..

[shanghendelei]

怎么样让数据只显示前5行啊,,用SQL语句写..

[akeyta]

像Oracle, MySQL数据库不支持top n的。

[shanghendelei]

select * from gongqiou where 型号 like '%" & session("xinghao") & "%' order by id desc"
我用这个时..无论给"xinghao"什么值..都是查出所有内容

[shanghendelei]

帮我看看这个看有什么问题..总是出现"请核对您的用户名和密码！"
<%@ Language=VBScript %>
<!--#include file=conn1.asp -->
<%
name=session("name")
psw=session("psw")

name=replace(name,"'","''")
psw=replace(psw,"'","''")

set rs5=server.CreateObject ("ADODB.RecordSet")
sql5="select * from user where 姓名='" & name & "' and password='" & psw & "'"
rs5.Open sql5,conn,1,3

if not rs5.EOF then
name=rs5.Fields ("姓名")
psw=rs5.Fields ("password")
' session("tjrname")=rs.Fields ("姓名")
Response.Redirect "chaxun.asp"
else
Response.Write "请核对您的用户名和密码！"
Response.End
end if
%>

[ly840325]

select top 5 * from 表名 group by 排序方式

[ourme]

select top 10 * from '表名'

[HawaiiLeo]

select top 5 * from '表名' group by 排序字段

[newdongkui]

1. select top 5 * from table

2. set rowcount 5
select * from yourtable

[mjhnet]

TOP

[zealberg]

:HawaiiLeo(罗马数字)
: select top 5 * from '表名' group by 排序字段

应该用Order By吧？

Select Top 5 * From TableName Order By theOrderField [DESC]

[zjcxc]

select top n * from table
n 是你要显示的行数,例如:显示前5行
select top 5 from table