Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL interview - Coggle Diagram

- - - - The first part of the column1
  - - - First n characters
- - - - Percentage
- - - - IF(revenue > 5000, 'Met', 'Not Met') as 'Goal'
- - - - Without holes in rank
    - - ROW_NUMBER() window function in SQL is used to assign a unique, sequential integer value to each row in a result set, based on the specified order
    - - give you the row BEFORE the row you are finding a value for
    - - give you the row AFTER the row you are finding a value for.