Retrieveing top 10 records from different companies .Write Sqlquery
I have two tables Company and Transactions.Company is having fields CompanyID,Companyname.Transactions is having fields CompanyId,Transactiondatetime.Now I want top 10 transactions from different companies by using the above tables.
Assume that there are 100 companies.How to write Sqlquery