欢迎投稿

今日深度:

SQL Server 如何查询最后一条记录

SQL Server 如何查询最后一条记录


 

 

 

 

 

 

select top 1 * from worklog_Info where UserID='1' order by serial desc


 

 

select * from worklog_Info

 

select * from worklog_Info where userid='1'

select top 1 * from worklog_Info where userid='1'

 

select top 1 * from work_Info where userid='1' order by serial desc

 

 

 

 

www.htsjk.Com true http://www.htsjk.com/shujukunews/80.html NewsArticle SQL Server 如何查询最后一条记录 select top 1 * from worklog_Info where UserID='1' order by serial desc select * from worklog_Info select * from worklog_Info where userid='1' select top 1 * from worklog_Info where userid='1' select...
评论暂时关闭