how i get only one row from sql select statement

[fuadhamidov]

hi
i want to get only one row by using sql select statement or an other way. when i use sql select i may return hundreds of rows, so it decrease the speed of program. is there any way to get only one line. my code like:
select date from <whatever> order by date

 

[dinzana]

In a nutshell, your SQL says...

'Show all of the dates in the whatever table and order them.'


If you want the most recent date, you should have something like this....

select max(date) from <whatever>

 

[fuadhamidov]

hi
thanks more
i have found
select top 1 date from <whatever> order by date