Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

demo

Language: Layout:
View schema
Execution time: 0 sec, rows selected: 4, rows affected: 0, absolute service time: 0,16 sec 
fork mode |  history 
  
(No column name)



1
SELECT Grade, COUNT(*) AS [Frequency] , (COUNT(*)* 100 / (Select Count(*) From tbldata)) AS [percentage]FROM tbldata GROUP BY Grade ORDER BY [Frequency] DESC






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development