[sql] How to use group by with union in t-sql

with UnionTable as  
(
    SELECT a.id, a.time FROM dbo.a
    UNION
    SELECT b.id, b.time FROM dbo.b
) SELECT id FROM UnionTable GROUP BY id

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to tsql

• Passing multiple values for same variable in stored procedure • Count the Number of Tables in a SQL Server Database • Change Date Format(DD/MM/YYYY) in SQL SELECT Statement • Stored procedure with default parameters • Format number as percent in MS SQL Server • EXEC sp_executesql with multiple parameters • SQL Server after update trigger • How to compare datetime with only date in SQL Server • Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot • Printing integer variable and string on same line in SQL

Examples related to group-by

• SELECT list is not in GROUP BY clause and contains nonaggregated column .... incompatible with sql_mode=only_full_group_by • Count unique values using pandas groupby • Pandas group-by and sum • Count unique values with pandas per groups • Group dataframe and get sum AND count? • Error related to only_full_group_by when executing a query in MySql • Pandas sum by groupby, but exclude certain columns • Using DISTINCT along with GROUP BY in SQL Server • Python Pandas : group by in group by and average? • How do I create a new column from the output of pandas groupby().sum()?

Examples related to union

• Simplest way to form a union of two lists • Group by with union mysql select query • How to execute UNION without sorting? (SQL) • SQL: how to use UNION and order by a specific select? • How can I get the intersection, union, and subset of arrays in Ruby? • UNION with WHERE clause • SQL Server: How to use UNION with two queries that BOTH have a WHERE clause? • Intersection and union of ArrayLists in Java • How to order by with union in SQL? • SELECT INTO USING UNION QUERY