Question : How can I group (by) two joined tables (in an Oracle database) like this: cant: id CANT_VAL COD_VAL […]
Tag: union
Using COLLATE with UNION
Question : How to use COLLATE with UNION? I want to union 2 tables (both have the same columns and […]
select distinct -> join 3 tables
Question : Hi i need to mix (more than join) three tables, but the id could be present or not […]
Is a UNION query equivalent with or without DISTINCT in subqueries?
Question : Consider the following two queries. SELECT Col1, Col2 FROM TblA UNION SELECT Col1, Col2 FROM TblB and SELECT […]
Get table name from union query?
Question : This is my query SELECT Id, productName, Largeimagepath, Discount, Price, Image FROM tablename1 where Active =1 union SELECT […]
Combining 2 SELECT queries and printing the results in PostgreSQL
Question : I have 2 queries which I want to use together to produce one output result to the user. […]
Understanding comparison operators on columns
Question : Consider this dummy_data: number 1 2 3 4 5 I want to return all the rows from dummy_data […]
How to make an union on 2 joined tables without affecting the sum on the column? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Without using ‘INTERSECT’ , How to retrieve only the rows that exist in both tables?
Question : I am a beginner reading the book Sams Teach Yourself SQL in 10 Minutes (Fifth Edition) to learn […]
Index lost while joining on union
Question : I read a lot about indexes/unions but can’t get to the bottom of this. I have here a […]