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
Parag Thakkar
NA
7
974
comparing SQL data from a single table
Apr 6 2018 7:12 AM
Hi
I have a table with following fields
1. DeviceID (unique ID)
2. Date (only date without time)
3. Time (only time)
4. Channel1 (value for channel 1)
5 Channel2 (value for channel 2)
There are multiple devices having different and unique DeviceID storing data in this table.
I have data for 2 devices say 1 and 2. Now I want to extract data in the following format:
Date, Time, Channel1 (for device 1), Channel1 (for device 2) for comparing channel1 values for both devices at different date and time.
Can any one help me as in how this can be achieved.
Reply
Answers (
2
)
Naming convention of Table and Fields name.
What is PL SQL? Will anyone please tell?