我如何从数据库中获取最后一条记录 [英] how can i get last record from database

问题描述

我想从数据库中获取最后一条记录


是否有与我们用来获取第一条记录的TOP类似的功能

SELECT TOP 1 sponcorid从Registration_Master

我希望此类函数获取上一条记录

i want to get last record from database


is there any similar function as TOP which we use to fetch 1st record

SELECT TOP 1 sponcorid FROM Registration_Master

i want such function to fetch last record

推荐答案

您可以尝试...

You could try...

SELECT TOP 1 sponcorid FROM Registration_Master
order by sponcorid desc 

基于唯一的ID号.

Based on unique id number.

SELECT *
FROM    TABLE
WHERE   ID = (SELECT MAX(ID)  FROM TABLE)

使用此查询从数据库获取最后一条记录.

Use this query to get last record from database.

这篇关于我如何从数据库中获取最后一条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！