sql-servert-sqlwindow-functions
strange ssms results about t-sql SUM func, couldn't figure out
I am learning t-sql window function when found something strange, here is the normal code, very simple.
then I tried delete the window frame clause and got the same results.
anyone can explain why the result of the second one, thanks.
Solution
The second query returns the same results, because "range between unbounded preceding and current row" is the default frame, as you can see in the documentation and there are no duplicated rows in your table (i.e. multiple rows with the same empid and ordermonth).
If ROWS/RANGE is not specified but ORDER BY is specified, RANGE UNBOUNDED PRECEDING AND CURRENT ROW is used as default for window frame.
- Audit table update trigger does not work using a stored procedure
- Entity Framework | Sequence contains more than one matching element
- How can I alter column name in Sql server
- How to partition into batch of records with max batch size limit
- LOAD DATA INFILE error in MySQL
- Cannot perform an aggregate function on an expression containing an aggregate or a subquery with STRING_AGG
- Perform a row count of each table in my list of tables
- Entity Framework Core 3.1.6 Item With Same Key Has Already Been Added
- Split a string with no delimiters into columns
- Each GROUP BY expression must contain at least one column that is not an outer reference
- Add custom columns to pivot table
- Parameterized raw sql query much slower than query with actual values
- SQL Server database backup restore on lower version
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- How can I create a unique constraint on my column (SQL Server 2008 R2)?
- Summation of a column using certain conditions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to Renumber Set/Subset of Table Based on Numbering of A Second Table
- Using Azure Devops deploy release to multiple repos
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?