Hi Vinay,
i have date col, but i am joining with another table. i am using where clause for date its not giving top 5 rows
Once again: There is no term "order of records in database".
If you want to get records with some order, you
must provide an ORDER BY clause. Without ORDER BY clause select returns unordered list of records, that occasionally
may be returned in the order you want. If you don't have a field that you can use to determine latest records - you wouldn't be able to get the last records in consistent manner. If you do have such a field - use ORDER BY [this field] DESC/ASC and select top records.
If you want to get more information about your particular case - provide us with DDL (data definition language: scripts for table creations) scripts and queries you're trying to run