Hide column in sql query output

Question

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

Well if you want to hide it - then don't list it in the SELECT list of columns! — marc_s
– marc_s, Commented Sep 26, 2017 at 5:28

Chris · Accepted Answer · 2017-09-26 05:41:58Z

3

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

answered Sep 26, 2017 at 5:41

Chris

858 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mr Slim · Accepted Answer · 2017-09-26 05:41:15Z

-1

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

edited Sep 26, 2017 at 5:41

answered Sep 26, 2017 at 5:32

Mr Slim

1,4563 gold badges19 silver badges29 bronze badges

3 Comments

user7870411 Over a year ago

hey i am getting the follwing error for this query .The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

Mr Slim Over a year ago

The inner query requires a TOP 100 PERCENT to cater for ORDER BY. Answer has been updated. This answer also assumes you are using SQL Server

user7870411 Over a year ago

The multi-part identifier "MProduct.ProductName" could not be bound. this is next error

Collectives™ on Stack Overflow

Hide column in sql query output

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related