Parag Thakkar

Parag Thakkar

  • NA
  • 7
  • 955

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. 
 
 

Answers (2)