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
akbar ansari
1.7k
63
2.1k
PIVOT table in sql
Mar 29 2023 10:55 AM
Date
TYPE
TIME
01-01-2020
A
01:20
01-01-2020
B
20:30
02-01-2020
A
10:01
02-01-2020
B
10:20
03-01-2020
A
11:01
03-01-2020
B
11:10
04-01-2020
A
11:21
04-01-2020
till month end
more TYPE (A,B)...
more times....(different times)
How can i present table in
TYPE
01-01-2020
02-01-2020
03-01-2020
04-01-2020
05-01-2020
06-01-2020
07-01-2020
A
01:20
10:01
B
20:30
10:20
Reply
Answers (
2
)
case in sql when in a single column there are rows with diff condition
How to relate 2 tables