on 05-31-2011 7:09 AM
Hi Gurus,
I have a question regarding Query and update SQL statement. I have a field in the DB named XXX_date. I need to get the record where the last query ended. Is this possible? For example, my last query was yesterday at 2pm. I want to get the records from today until 2:01pm of yesterday.
Thanks!!!
select empid, name, max(XXX_date) XXX_date from group by id,year
Juss check this out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can do that easily i think
Last updated record date value is going to have maximum, you can try with max , but i feel this is not good idea.
google it...you will find solution.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.