I am trying to select "log_comment" field with the max("stamp_date") field from "action_log" table where "field_index" field ='1007'
I am getting more than just the row with the maximum stamp_date. Can someone please tell me what I'm doing wrong?
Field_Index Stamp_Date Log_Comment
1007 2011-05-12 posting not complete
1007 2011-06-08 Pulled temporarily
1007 2011-04-15 PO needs to be received in Meditech please
10526 2011-04-06 General Matching
Software/Hardware used: SQL Server Management Studio
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!