#sqlforramm 搜索结果
Ready to power up your RAMM use? Do you want to see some bite-sized snippets of RAMM SQL code? Looking to brush up on your RAMM SQL skills? We are launching a new little social media based project shortly…. The #SQLforRAMM project. Coming soon! #SQLforRAMM
Kicking #SQLforRAMM off with some basics. This simple query will show you all of the carriageway sections defined in your network. Remember; the #SQLforRAMM project is showing different code and concepts available to you, not the only way / definitive way to do something.
Building on the previous entry in the series, this time we use NOT IN instead of <> to exclude carriageway sections where the asset owner is local authority. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
This SQL code will return all the carriageway sections, where the asset owner is something other than Local Authority (which is the default owner in a NZ local road database). Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
Need to know the number of “roads” for each road type in your RAMM database? Then steal this SQL code to find out. Just remember the road names table in RAMM isn’t necessarily just for roads. It could include other network features like paths, car parks & reserves #SQLforRAMM
Continuing to build on the NOT IN concept from our previous entry. This time round we are excluding multiple ownership types (local authority AND private) in one go, through the use of comma separated values. Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM
In this script we use the SUM keyword to add all the values together in the length_m column. This will return you the entire 'network length' in metres (i.e. the sum of every single carriageway record in your database). Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM
In this script we build on our previous code by adding a GROUP BY to our SUM of the length_m column. This will return you the entire network length for each of the different carriageway hierarchies used on your network. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
Generate a list of Road Names and Road ID's in your network, with this simple little bit of SQL code. In this script we are querying the roadnames table and returning just two specific columns; road_id and road_name. #SQLforRAMM #RAMM #RAMMSoftware #RAMMAssetManagement #SQL
In this script we build on our previous code by adding a GROUP BY to our SUM of the length_m column. This will return you the entire network length for each of the different carriageway hierarchies used on your network. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
In this script we use the SUM keyword to add all the values together in the length_m column. This will return you the entire 'network length' in metres (i.e. the sum of every single carriageway record in your database). Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM
Continuing to build on the NOT IN concept from our previous entry. This time round we are excluding multiple ownership types (local authority AND private) in one go, through the use of comma separated values. Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM
Building on the previous entry in the series, this time we use NOT IN instead of <> to exclude carriageway sections where the asset owner is local authority. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
This SQL code will return all the carriageway sections, where the asset owner is something other than Local Authority (which is the default owner in a NZ local road database). Steal this SQL code to try it out in RAMM SQL #SQLforRAMM
Need to know the number of “roads” for each road type in your RAMM database? Then steal this SQL code to find out. Just remember the road names table in RAMM isn’t necessarily just for roads. It could include other network features like paths, car parks & reserves #SQLforRAMM
Generate a list of Road Names and Road ID's in your network, with this simple little bit of SQL code. In this script we are querying the roadnames table and returning just two specific columns; road_id and road_name. #SQLforRAMM #RAMM #RAMMSoftware #RAMMAssetManagement #SQL
Kicking #SQLforRAMM off with some basics. This simple query will show you all of the carriageway sections defined in your network. Remember; the #SQLforRAMM project is showing different code and concepts available to you, not the only way / definitive way to do something.
Ready to power up your RAMM use? Do you want to see some bite-sized snippets of RAMM SQL code? Looking to brush up on your RAMM SQL skills? We are launching a new little social media based project shortly…. The #SQLforRAMM project. Coming soon! #SQLforRAMM
SQL Basics to Advance Notes 📘 To get it ✅ 1. Like and comment 'SQL' 2. Repost 🌠 3. Follow me so that, I can dm. #SQL
🚨BREAKING: Claude Sonnet 4.5 just dropped… But I’m not paying $200 to use it. I just found a secret website where new users get GPT-5 for free — and Sora 2 is available too. Here’s how 👇
SQL Interview Questions & Answers You Should Know. To get: - 1. Follow (So I can DM you ) 2. Like & retweet 3. Reply "SQL"
Stop using Venn diagrams to explain SQL joins. These 4 images provide a more logical alternative:
Every database needs structure. Data types define what kind of information lives in your tables. #SQL #DatabaseDesign #DataAnalytics
if your production db doesnt look like this, are you even an LLM whisperer
✨ SQL Roadmap ✨ We just published a new interactive guide for learning SQL. Check it out 👇 roadmap.sh/sql
Something went wrong.
Something went wrong.
United States Trends
- 1. Friendly 62.6K posts
- 2. SNAP 724K posts
- 3. Grokipedia 7,935 posts
- 4. #ChiefsKingdom 3,060 posts
- 5. Mac McClung 1,775 posts
- 6. Riley Gaines 39.3K posts
- 7. Big Dom 2,009 posts
- 8. Game 3 60.8K posts
- 9. Brad Paisley N/A
- 10. #jeopardyblindguess N/A
- 11. Monday Night Football 7,844 posts
- 12. #JUNGKOOKXCALVINKLEIN 68.1K posts
- 13. James Wiseman N/A
- 14. Jamaica 118K posts
- 15. Runza N/A
- 16. #OTGala6 175K posts
- 17. Jessica 27.6K posts
- 18. #boolivia N/A
- 19. Cher 17.2K posts
- 20. Cade Cunningham 1,363 posts