SQL Database reading

I’m working on creating a simple application to display appliance test results on a TV display. I am going to be collecting data from a SQL Database and placing the Data into a Data Table. Each test has several different defects that are checked and stored on this database. The display needs to show the top 5 most common defects for the current day. Can you guys give me some suggestions of how to go about sorting the table and reading through it to find how many appliances failed for each specific defect. Remember an appliance can and most likely will fail for a couple different defects if it’s faulty.

Are you talking about reading data from a NETMF device that supports SQLite? If not, I don’t think this has relevance to this forum and would be better placed in Off Topic.

good call. That’s my fault. I will repost in a more appropriate place

DONT REPLY to this thread.