Hello everyone,
I am using SQL Server 2008. I have a table which is composed of three columns, ID as string type, createtime as DataTime type and status as int.
I want to select the record among all records whose status value is 10 and at the same time createtime is the most earlist. Any ideas how to write such query?
BTW: ID is clustered index and I also have index on createtime column.
thanks in advance, George