Future minutes - Technology Trends – Technology guidelines

#Trending
MS SQL SERVER
.NET
ASP.NET
.NET CORE
BOOTSTRAP
JAVASCRIPT

How to get top 1 record of each group in sql? Ask Question

By Adil Shahbaz 17-Nov-2024 1


;WITH cte AS
(

   SELECT *,

         ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Date DESC)
 AS rn

   FROM Table
)

SELECT *
FROM cte

WHERE rn = 1

Solutions

10099

For Submision Log in first

Submit Post
Article
Ask a Question
Ask an Interview Question
Submit Useful Links

Update on: Dec 20 2023 05:10 PM

Messages
Notifications

messages

Ibrahim Ahmed Helo dear i wanna talk to you
Fatima J. Helo dear i wanna talk to you
Fawad Ahmed Helo dear i wanna talk to you
Saim Turan Helo dear i wanna talk to you
Alis wells Helo dear i wanna talk to you

view all

notifications

Alis wells recommend your post
Alis wells share your post a good time today!
Alis wells recommend your post
Alis wells share your post a good time today!
Alis wells recommend your post

view all

Login

Solutions

Follow Us

messages

notifications

Solutions

Invite Colleagues

Send Message

messages

notifications

Login

Login Required

Please login if you registered For this Action.

Login

Login Required

Please login if you registered For this Action.

Share To!

Jack Carter

Xang Ching

Emma Watson