Watch Pre-recorded Live Shows Here
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Raju Fodse
1.9k
235
21.4k
Retrieve data on MAX Date
Jan 8 2021 9:13 AM
Hi! I have Salary Table and I want to retrive data on Max date. following is table
ID
EMP ID
FROM DATE
BASIC
DA
1
LPPL078
01-01-2019
5000
1000
2
LPPL077
01-01-2019
4000
1000
3
LPPL078
01-01-2020
6000
1200
and output should be as fallow
ID
EMP ID
MAX DATE
BASIC
DA
2
LPPL077
01-01-2019
4000
1000
3
LPPL078
01-01-2020
6000
1200
what shold query to retrive above output? pls help....
Reply
Answers (
2
)
How to migrate power bi reports to power bi services.
About Access SQL