/explore
|
You are here 
|
dylanpaulus.com | ||
| | | | |
markcarrington.dev
|
|
| | | | | The big new feature in this update is Common Table Expression support and enhanced JSON functionality. Common Table Expressions (CTEs) are a part of SQL that really made me rethink what is possible in the language when I first discovered them. For those that haven't used them before and don't Continue Reading | |
| | | | |
jsloop.net
|
|
| | | | | Let's say our objective is to get latest one row by a given set of criteria. Means, say a person has multiple products and we want to get latest one product per person. For this what we need to do is partition the data by the required criteria. Here we will partition the data by person_id and product_type ordered by latest org_insert_dt. This will order the result by person and latest product. Then we use row_number() function which will assign unique, sequential integer to each partition in the result set. Which means the latest product for each person will get a 1. And we use a CTE (Common Table Expression), which is temporary named result set to store this relationship. Now if we need latest product per person, then we can query this CTE which is like a t... | |
| | | | |
data36.com
|
|
| | | | | Learning SQL is very useful for anyone who wants to have a career in the online world. And it's a definite must for Data Analysts and Data Scientists! | |
| | | | |
sqlserver-help.com
|
|
| | | 1 post published by blakhani on June 1, 2011 | ||
