CODEWITHSUNDEEP
sqlhide
user7870411
user7870411

Reputation:

Hide column in sql query output

SELECT 
    MProduct.ProductCode, MProduct.ProductName, COUNT(*) AS Ranges
FROM 
    TProblem 
FULL OUTER JOIN
    MProduct ON TProblem.ProductCode = MProduct.ProductCode 
GROUP BY  
    MProduct.ProductCode, MProduct.ProductName 
ORDER BY 
    Ranges DESC

This is my query but I want to hide the Ranges column from output

Upvotes: 0

Views: 26509

Answers (2)

Chris
Chris

Reputation: 85

To maintain the order of your results, just move the count from your select to the order by: 

SELECT 
    MProduct.ProductCode, MProduct.ProductName
FROM 
    TProblem 
FULL OUTER JOIN
    MProduct ON TProblem.ProductCode = MProduct.ProductCode 
GROUP BY  
    MProduct.ProductCode, MProduct.ProductName 
ORDER BY 
    count(*) DESC

Upvotes: 3

Mr Slim
Mr Slim

Reputation: 1468

I understand where @marc_s is coming from. It looks like you are trying to get a list of DISTINCT rows

SELECT ProductCode, ProductName
FROM
(
SELECT TOP 100 PERCENT
    MProduct.ProductCode, MProduct.ProductName, COUNT(*) AS Ranges
FROM 
    TProblem 
FULL OUTER JOIN
    MProduct ON TProblem.ProductCode = MProduct.ProductCode 
GROUP BY  
    MProduct.ProductCode, MProduct.ProductName 
ORDER BY 
    Ranges DESC
) AS DATA

Or alternatively

SELECT DISTINCT 
    MProduct.ProductCode, MProduct.ProductName
FROM 
    TProblem 
FULL OUTER JOIN
    MProduct ON TProblem.ProductCode = MProduct.ProductCode 
    MProduct.ProductCode, MProduct.ProductName

Upvotes: 0

Related Questions