Breaking News: Grepper is joining You.com. Read the official announcement!

sql server select last documento for each customers

Add Answer

Angry Albatross answered on October 25, 2022 Popularity 1/10 Helpfulness 1/10

Contents

answer sql server select last documento for each customers

More Related Answers

sql server last executed query

how to get last row of table in sql

sql select last id

sql get table last modified time

SQL select last record in a table

get last record in sql

get last 50 rows sql

sql get last primary key inserted

sql get last ID

sql server select last row of each item in group by column

How to read the last row with SQL Server

how to check last index rebuild sql server

sql server select last row of each item in group by column

last date for each user sql

how to get last element sql

get last inserted record in sql

sql server select last row of each item in group by column

sql server select last row of each item in group by column

sql server select last row of each item in group by column

Last elements in database

sql server select last documento for each customers

Comment

0

with c as (
      select customer_id from customers1 union all
      select customer_id from customers2
     )
select o.*
from c left join
     (select o.*,
             row_number() over (partition by customer_id order by datecreated desc) as seqnum
      from orders o
     ) o
     on c.customer_id = o.customer_id and seqnum = 1;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: each select sql sql-server

Share

Link to this answer
Share Copy Link

Angry Albatross

Contributed on Oct 25 2022

Angry Albatross

0 Answers Avg Quality 2/10

X

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

X

Grepper Account Login Required

Oops, You will need to install Grepper and log-in to perform this action.

Install Grepper Here