--或者 select B.companyName from joblist A,company B where A.username=B.username group by B.companyName order by A.f_time
select distinct B.companyName from joblist A,company B where A.username=B.username order by A.f_time 这一句提示:order by 与distinct冲突select B.companyName from joblist A,company B where A.username=B.username group by B.companyName order by A.f_time 错误提示:试图执行的查询中不包含作为合计函数一部分的特定表达式
--不好意思,没测试,这个应该可以 select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName order by f_time
--测试数据 CREATE TABLE joblist(ID INT,username varchar(20),jobName varchar(30), jobShi varchar(30), IsPass varchar(10), f_time datetime) insert joblist select 434, 'huatai ' , '律师助理' ,'乌鲁木齐市', 'true', '2005-9-9 10:41:55' insert joblist select 435, 'xiaodianti', '商务代表' ,'苏州市', 'false', '2005-9-9 10:41:55' insert joblist select 436, 'huatai' ,'律师助理' ,'乌鲁木齐市', 'true', '2005-9-9 10:41:55' insert joblist select 437, 'huayang' , '商务代表' ,'苏州市', 'false', '2005-9-9 10:41:55' insert joblist select 438, 'huayang' , '热线人员' ,'苏州市', 'false', '2005-9-6 10:41:55' insert joblist select 439, 'huayang' , '行政总监表','苏州市', 'false', '2005-9-5 10:41:55' insert joblist select 440, 'huayang' , '热线人员' ,'苏州市', 'false', '2005-9-9 10:41:55'create table company(ID int, username varchar(20), companyName varchar(30), shi varchar(30), regtime datetime) insert company select 239, 'huayang', '新千禧计算机学校', '苏州市', '2005-5-27 11:24:36' insert company select 240, 'huatai', '法国芳汀世家国际美容', '济南', '2005-8-29 11:24:36' insert company select 241, 'qianqian', '济南正业管理咨询有限公司', '苏州市', '2005-8-27 11:24:36' insert company select 242, 'dadi', '山东峨嵋集团', '济南市', '2005-8-27 11:24:36' --查询 select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName order by f_time--结果 companyName f_time ------------------------------ ------------------------------------------------------ 法国芳汀世家国际美容 2005-09-09 10:41:55.000 新千禧计算机学校 2005-09-09 10:41:55.000(所影响的行数为 2 行)--如果只要公司名 select companyName from (select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName) a order by f_time--结果 companyName ------------------------------ 法国芳汀世家国际美容 新千禧计算机学校(所影响的行数为 2 行)
select B.companyName from joblist A,company B where A.username=B.username group by B.companyName order by A.f_time
这一句提示:order by 与distinct冲突select B.companyName from joblist A,company B where A.username=B.username group by B.companyName order by A.f_time
错误提示:试图执行的查询中不包含作为合计函数一部分的特定表达式
select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName order by f_time
CREATE TABLE joblist(ID INT,username varchar(20),jobName varchar(30), jobShi varchar(30), IsPass varchar(10), f_time datetime)
insert joblist select 434, 'huatai ' , '律师助理' ,'乌鲁木齐市', 'true', '2005-9-9 10:41:55'
insert joblist select 435, 'xiaodianti', '商务代表' ,'苏州市', 'false', '2005-9-9 10:41:55'
insert joblist select 436, 'huatai' ,'律师助理' ,'乌鲁木齐市', 'true', '2005-9-9 10:41:55'
insert joblist select 437, 'huayang' , '商务代表' ,'苏州市', 'false', '2005-9-9 10:41:55'
insert joblist select 438, 'huayang' , '热线人员' ,'苏州市', 'false', '2005-9-6 10:41:55'
insert joblist select 439, 'huayang' , '行政总监表','苏州市', 'false', '2005-9-5 10:41:55'
insert joblist select 440, 'huayang' , '热线人员' ,'苏州市', 'false', '2005-9-9 10:41:55'create table company(ID int, username varchar(20), companyName varchar(30), shi varchar(30), regtime datetime)
insert company select 239, 'huayang', '新千禧计算机学校', '苏州市', '2005-5-27 11:24:36'
insert company select 240, 'huatai', '法国芳汀世家国际美容', '济南', '2005-8-29 11:24:36'
insert company select 241, 'qianqian', '济南正业管理咨询有限公司', '苏州市', '2005-8-27 11:24:36'
insert company select 242, 'dadi', '山东峨嵋集团', '济南市', '2005-8-27 11:24:36'
--查询
select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName order by f_time--结果
companyName f_time
------------------------------ ------------------------------------------------------
法国芳汀世家国际美容 2005-09-09 10:41:55.000
新千禧计算机学校 2005-09-09 10:41:55.000(所影响的行数为 2 行)--如果只要公司名
select companyName from (select B.companyName,max(A.f_time) f_time from joblist A,company B where A.username=B.username group by B.companyName) a order by f_time--结果
companyName
------------------------------
法国芳汀世家国际美容
新千禧计算机学校(所影响的行数为 2 行)
http://community.csdn.net/Expert/topic/4258/4258836.xml?temp=.8371546
xueguang(xg)大哥,这两个也来留个名,分数一并给您了吧,太感谢您了!
语法错误!(操作符丢失)!在查询表达式'max(A.f_time) f_time'中
别的我搞定,谢谢