TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
victor ebe
NA
68
0
Write Query The row with the highest ID Per day
Mar 18 2015 5:04 PM
You have 3 fields ID Date and Total Your table contains multiple rows for the same day which is valid data however for reporting purpose you need to show only one row per day. The row with the highest ID Per day should be returned the rest should be hidden from users( not returned)
Reply
Answers (
1
)
Write Query you have 2 record website traffic.
How to handle Temp Table? why i need Temp Table