SQL Query!!!?

Question

My Query is

In my table there is a field name
date and i want to sort on this field & want date from first & last record not in between, using single SQL Query

Plz help its urgent.

Answer 1

SELECT *
FROM TABLENAME
WHERE DATECOLUMN between '2003-04-09'
AND '2003-04-10'
ORDER BY DATECOLUMN

Answer 2

What you would like to do is create an answer by using SQL.
A better and more efficient answer would be to do the select that you have described and then use program code to do some action with the first and the last item.

Answer 3

can you pls explain more on your requirements?

you want to sort by name, suppose there are five names - but first one is ALI and last one is ZAFAR.

do you want dates for these records only?

Answer 4

select * from MyTable where MyDate
in
((select max(MyDate) from MyTable) union
(select min(MyDate) from MyTable))

Any records that are on the Maximum date, and any records that are on the Minimum date will be returned.