Thanks it helped. On Sat, Nov 1, 2014 at 2:09 PM, Stephen Cook <scli...@gmail.com> wrote:
> On 11/1/2014 2:27 AM, VENKTESH GUTTEDAR wrote: > >> I have a table in which i have some few fields, in that few, one >> field is of date type and second one is of time data type, so now my >> question is how can i fetch the data with latest date and time, or the last >> inserted value from the PostgreSQL Table.? >> > > SELECT * > FROM mytable > ORDER BY datecolumn DESC, > timecolumn DESC > LIMIT 1; > > > You might want to put an index on them. > > -- Stephen > > -- Regards : Venktesh Guttedar.
