原表AID NAME TEL INTIME OUTTIME
---------------------------------------------
1 a 123 2011-1-1
2 b 234 2011-5-5
3 c 345 2011-3-3
4 d 456 2011-4-4
5 e 567 2011-2-2结果
ID NAME TEL TIME
---------------------------------
1 a 123 2011-1-1
5 e 567 2011-2-2
3 c 345 2011-3-3
4 d 456 2011-4-4
2 b 234 2011-5-5
---------------------------------------------
1 a 123 2011-1-1
2 b 234 2011-5-5
3 c 345 2011-3-3
4 d 456 2011-4-4
5 e 567 2011-2-2结果
ID NAME TEL TIME
---------------------------------
1 a 123 2011-1-1
5 e 567 2011-2-2
3 c 345 2011-3-3
4 d 456 2011-4-4
2 b 234 2011-5-5
SELECT ID,Name,Tel,ISNULL(INTime,OutTime) AS Time
FROM [Table]
ORDER BY Time
from a
order by [time]
select ID,NAME,TEL,INTIME as [TIME]
from a
order by INTIME
from a
order by time
from a
order by time
FROM [Table]
ORDER BY INTime