Copy of same table and get the records

[Waqas ali]

dear all,

i have a table with date and time in single column from that column i got min date&time and max date&time against each jobid.

now in same table there are more entries in between min and max date&time range i want to retrieve if it exist in between min and max date&time range.

how to write a sub query i put alias for min as startjob and max as endjob but sub query is not accepting these alias in itself.

 

[Micron]

Always post code or sql that you tried. You could be 99% there but are asking someone to start from scratch. See 'tips' below. You might need a second query that uses the first as a data source to provide the dates (you say you got min and max date&time already) and a field in the second query gets all the records that span those dates. If you use the BETWEEN operator in your second query, there is a not so well known issue about how it handles date fields that also have time. Might be best to use >= and <=.