Using SQL like Excel - First example

Using SQL like Excel - First example

Andrea Salzano Andrea Salzano

Andrea Salzano

Oracle PL/SQL Developer at Lottomatica S.p.A.

发布日期: 2024年7月10日
+ 关注

In my previous post, I have shown the relation between SQL MODEL clause and an Excel spreadsheet.

In this post, you can see a sample on how it works. It is a first of a few posts I'll write on MODEL clause.

In the post, you can see how to realize the same result in SQL.

In the following image, King haven't the percentage of commission, but I set it with the formula C14*0,45 (here I'm using the comma as decimal separator). How you can see, in the spreadsheet, only King the salary_bonus is modified

The result from Excel

SQL allow you to obtain the same result

The result set from SQL


要查看或添加评论，请登录

Andrea Salzano的更多文章

  • 2 physical concepts in Oracle database
    2024年7月25日

    2 physical concepts in Oracle database

    It could be strange, but yes, there are 2 concepts that came from physic that you can apply to your oracle database…

  • How to rescue data after a mistake
    2024年7月16日

    How to rescue data after a mistake

    Oracle give you the opportunity to recover data also if you delete them or dropped the table. Here 2 simple example…

  • Using SQL like Excel
    2024年7月5日

    Using SQL like Excel

    SQL allow you to manage a result set as a spreadsheet. It is possible using the MODEL clause.

  • MATCH_RECOGNIZE order of application
    2024年6月26日

    MATCH_RECOGNIZE order of application

    Starting 12c, Oracle introduced THE MATCH_RECOGNIZE analytic function to recognize patterns. IF you are NEW TO this…

  • Analytic Function preserve the partitioning
    2021年7月21日

    Analytic Function preserve the partitioning

    Analytic Functions are great. They are SQL standard so all databases implement them.

  • ITOUG Tech Day 2019 (Milano)
    2019年1月31日

    ITOUG Tech Day 2019 (Milano)

    Il primo giorno del Tech Day 2019 a Milano, si è concluso. Alla grande dire.

    2 条评论
  • ITOUG 2019: Oracle, Mediamente, R1
    2018年12月13日

    ITOUG 2019: Oracle, Mediamente, R1

    L'ITOUG event che si terrà il 30/Gennaio/2019 a Milano ed il 01/Febbraio/2019 a Roma è stato possibile grazie a tre…

  • ITOUG 2019: ancora insieme
    2018年11月22日

    ITOUG 2019: ancora insieme

    Ormai ci abbiamo preso gusto. E' bello iniziare un nuovo anno (più o meno :) sapendo che poi sarà tutto in discesa.

  • ITOUG 2019 Thech Days
    2018年10月10日

    ITOUG 2019 Thech Days

    Finalmente ci siamo. il 30 Gennaio ed il 1 Febbraio IOTUG organizzerà un nuovo evento.

  • Blocking session
    2018年8月16日

    Blocking session

    Some time ago, I wrote a post on how to show a chain of blocked sessions. In this days Kaley Crum wrote a new version…

社区洞察

其他会员也浏览了