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
MonthlyLeaders
ASK A QUESTION
Forumguidelines
Karan Singh
1.9k
60
2.3k
Find duplicate row and differentiate with date
Jan 22 2018 2:11 AM
Hi any one hep me?
I have table in sql like:
RateDate Currency MinLos MaxLOS CutOff Availability
2018-06-01 INR 12 15 0 5
2018-06-02 INR 12 15 0 5
2018-06-03 INR 3 13 2 4
2018-06-04 INR 5 12 4 20
2018-06-05 INR 5 12 4 20
2018-06-06 INR 8 1 5 2
my out put should be like this
RateDate Currency MinLos MaxLOS CutOff Availability
2018-06-01 - 2018-06-02 INR 12 15 0 5
2018-06-03 - 2018-06-03 INR 3 13 2 4
2018-06-04 - 2018-06-05 INR 5 12 4 20
2018-06-06 - 2018-06-06 INR 8 1 5 2
Please help me ASAP.
Reply
Answers (
4
)
how to fetch the pin code in address using sql query
Differance in IiF() FUNCTION AND Case Statement???