列出业务帐号ID,unix服务器ip地址,os帐号,开通时间,结果集按unix服务器ip地址升序,开通时间降序显示,下列sql语句正确的是:( )
select id,unix_host,os_username,create_date from service order by unix_host,desc create_date;
select id,unix_host,os_username,create_date from service order by desc unix_host, desc create_date;
select id,unix_host,os_username,create_date from service order by unix_host desc,create_date desc;
select id,unix_host,os_username,create_date from service order by unix_host,create_date desc;