Skip to content
Advertisement

How to Use Queries to show records based on conditions

I have an SQL query that selects data based on uploaded and not uploaded

this is the query am using to achieve the data above

I want to go a step further and group the data into two columns. I want to get the labnames grouped using the uploadstatus that is 0 as Not Uploaded and the ones having 1 as Uploaded and represent it in two columns.

This what I am trying to achieve from the drilldown

How can I group the data using uploadstatus column and group them in new columns and separate the ones with the value of 0 to one column and the others with value of 1 to another column? Any help will be appreciated

Advertisement

Answer

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement