Just curious if in SQL there was an easy way to pull up the latest data from a database for different locations. I have a database that contains inspection results for many different locations. I wanted to pull up the latest inspection for each site and make a report on it. I thought the "TOP" command might work, and it does for just one site. I would think that SQL would be able to handle that easily, but I have not been able to find anything in SQL that will do it. Just was wondering if I have missed something in SQL. I was able to do what I wanted in VBA. Thanks -- Gary
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#116784) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar