Difference Between LINQ and SQL Select with Group by Query  Syntax.

The select statement is used in SQL to specify what data you would like returned when querying the MSSQL MYSQL LINQ database. An asterisks [*] will return all data, or you can choose specific data.

The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns in SP View and Table data.

SQL : select(clause) * from (clause) from <table Name> where(clause) column =value 

        group by(clause) column name  order by   column name desc

           select * from customer where id =100  group by id order by created_date desc

LINQ : from <instance> in <table name or table object name> where (clause) column=value

            groupby(clause) ColumnName   orderby(clause) columnName asc   select <instance>

           from cust in customer where cust.id. Equuleus (100) groupBy cust.id
           orderby cust.created_date desc   select cust;