关于sql'列表的问题(the problem which is about listing of sql')

   IT问题网   2020-06-28 00:00:00

问 题

我想得到3个最后用"'select命令'添加的数据。但是,我已经完成的命令,不是前三个命令,而是所有这些命令,或者我要添加一个计数器或者其他什么那样的吗?你能帮帮我吗?

解决方案

如果你真的想要检索添加到数据库的最后三个项目,那么我会用一个数据库字段来保留输入日期和时间,并检索按该字段排序的top三项:

  select   top   3  *  from  mytable  order   by  dateposted  desc  

标签:关于列表问题



分享:

  • 微信
  • QQ好友
  • QQ空间
  • 新浪微博


热门推荐

DataGridView绑定源datacontext.ExecuteQuery allowusertoaddrows已禁用(DataGridView Binding Source datacontext.ExecuteQuery allowusertoaddrows disabled)

problem using the following code: iqueryable data = db.e ...

我想在每个页面上显示用户名(I want to display username on every page)

problem can i use loginview control without login control ...

解释如何重载.ToString()方法......(Explain how to overload .ToString() method...)

problem help me friends... :) thanks in advance... soluti ...

UserControl编辑对象(UserControl to edit an object)

problem hello, i have a usercontrol that has some fields ...

使用任何网络服务获取英国的邮政编码和地址(get postal code and address of UK using any web service)

problem hi, i have 2 text box. 1 for u.k. p ...

Windows 7的应用程序(application for windows 7)

problem do i need to install anything to program an app u ...

将控件添加到datagridview(add control to datagridview)

problem hi, there is a control called nbtext (which forma ...

多列和网格下拉列表(无自动完成)(dropdown with multicolumn and grid(no autocomplete))

problem i need a dropdown with multicolumn like the follo ...

如何创建oracle数据库DSN?(how to create oracle database DSN)

problem respected sir/mam i have a oracle database in my ...

获取dataTable中字符串的长度(get length of a string in dataTable)

problem hiii all i make a for loop on datatab ...

使用大型数据库(working with large databases)

problem hi, we use sql server 2008 database ...

数据列表中的CountDown计时器(CountDown timers in a datalist)

problem im developing a auction website where students fr ...

插入记录器的问题(problem in inserting recorod)

problem cmd = new sqlcommand("insert into login1 values" ...

显示行到列(Display Row to Column)

problem how row to column value display in crystal report ...

Gridview中的复选框(Check box in Gridview)

problem if i check checkbox in gridview after that if i c ...

更新DatagridView记录(Updating DatagridView Records)

problem what am i doing wrong i can seem to u ...

如何从tortoiseSVN获取最新版本,然后使用CruiseControl.NET在msbuild中构建它(how to get latest version from tortoiseSVN and then build it in msbuild with CruiseControl.NET)

problem hi, i had a one asp.net solution in ...

请再帮忙,善良的人(Please help again, kind people)

problem hi all, so frustrated. i did two days'' researc ...

如何使用c#,net动态地在textarea中添加文本?(how to add text in textarea dynamically using c#,net)

problem string query = string.empty; query = "select mess ...

在Visual Studio 2010中创建Crystal Reports(Creating Crystal Reports in Visual Studio 2010)

problem im creating crystal reports using visual studio 2 ...