从sql中选择Data [英] Select Data from sql

问题描述

我有一些像这样的桌子 - >

 table jobdetails（
 JobNo int，
 Techname varchar，
完成日期）

表用户（
用户名varchar ，（这个和技术名称相同）
 groupname varchar（示例技术）

i拥有超过25个技术用户表。

i希望根据完成日期检查最顶层的技术。在我看来，我只需要选择每一项技术并计算它们今天完成的数量。并相互比较并显示数据有没有其他选择我可以使用没有选择25技术

分开？如果你做了这样的事情，请给我一些想法。谢谢

解决方案

< blockquote>尝试：

  SELECT   TOP   1  *  FROM  Jobdetails 
  ORDER   BY 已完成 DESC  

如果您希望从用户获得所有技术人员完成的表格和工作，请尝试以下方法：

  SELECT  u.username，u.groupname，COUNT（j.completed）） AS  CompletedJobsCount 
  FROM  [users]  AS  u  LEFT   JOIN  jobdetails  AS  j  ON  u.username = j.Techname 
  WHERE  j.completed = ' < span class =code-string> 2015-03-29' 
  GROUP   BY  u.username，u.groupname 

i got some tables like this ->

table jobdetails(
JobNo int,
Techname varchar,
completed date)

table users(
username varchar,(this one and techname are same)
groupname varchar (example tech)

i have more than 25 tech users in the table .
i want to check top most tech based on completed date. in my mind only i have to select each one tech and count how many they completed today. and compare with each other and show the data back. there is any other option i can use without select 25 tech
seperatly? give me some idea if you done something like this. thanks

解决方案

Try:

SELECT TOP 1 * FROM Jobdetails
ORDER BY Completed DESC

If you want to get all techs from users table and jobs completed by each of them, try this:

SELECT u.username, u.groupname, COUNT(j.completed)) AS CompletedJobsCount
FROM  [users] AS u LEFT JOIN jobdetails AS j ON u.username = j.Techname
WHERE j.completed = '2015-03-29'
GROUP BY u.username, u.groupname

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