sql查询帮助 [英] sql query help

问题描述

我需要查询表中的最后5个maxkey.

我有一个查询，但它只返回一个值.

这是我的查询:
从bkcrtkts中选择max(bkcrtkey)

Hi,

I need a query for select last 5 maxkeys from my table.

I have one query but its returns only one value.

This is my query:
SELECT max(bkcrtkey) FROM bkcrtkts

推荐答案

从TOP 5中选择bkcrtkeys从bkcrtkts排序由bkcrtkey DESC

SELECT TOP 5 bkcrtkey FROM bkcrtkts ORDER BY bkcrtkey DESC

尝试，

SELECT 
   TOP 5 bkcrtkey 
FROM bkcrtkts 
ORDER BY bkcrtkey DESC

选择前5名 列名 FROM TABLE_NAME 排序依据 COLUMN_NAME SORTING_ORDER

这篇关于sql查询帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！