Skip to main content

Posts

Getting Highest Entered Records from the Table (SQL Server)

If you want to get the highest entered records (transactions) in the current month you may write the query below select top 1 CourseID,count(*) as forms from dataform where month(DataFormDate)=MONTH(GETDATE()) group by CourseID order by forms desc when you want more than one records change the top 1 to the desired numbered.
Recent posts