max date records from a table
864099Oct 19 2011 — edited Oct 20 2011Hi everyone.
I have a table called shipment_refnum
when i use select * from shipment_refnum where shipment_refnum_qual_gid='BM" order by insert_date desc;
For this table max(insert_date) is 03-0ct-11. for above sql it shows many records for shipment_refnum_qual_gid='BM" and inser_date with 03-oct-11.
But when I use the the sql select * from shipment_refnum where shipment_refnum_qual_gid='BM' and insert_date=(select max(insert_date) from shipment_refnum);
it is displaying only one record.
can any one suggest me where i am going wrong.