显示排名第一的前三个最高的人. [英] Display 1st three highest paid persons.

查看:106
本文介绍了显示排名第一的前三个最高的人.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

示例
我创建了一个禁忌员工
然后我插入所有数据
但我只想找到3个获得最高薪水的人.

example
i create a taboe employee
then i insert all data
but i want to find only 3 person who getting maximum salary

推荐答案

这里是您需要的一切: ^ ]
Here is everything you need: SELECT TOP[^]


不,对不起,一句话也听不懂.
尝试详细说明问题所在.
此刻,您好像只是在输入一小部分作业-哈哈哈-但是您不会那样做吗?
No, sorry, don''t understand a word of that.
Try giving more detail as to what your problem is.
At the moment, it just looks like you typed in a small part of your homework - ha ha ha - but you wouldn''t do that, would you?


在您的作业中添加另一个问题问题-只为您-如果最高薪水是1000&我有10个这样的员工?一旦得到这3个人的东西,请三思!
Adding another question to your question - only for you - What if the highest paid salary is 1000 & i have 10 employees like that? Do think over it, once you get this 3 person thing!


这篇关于显示排名第一的前三个最高的人.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆