How can extract all possible values of one field and their corresponding description form a table?

1

Here is an example table:

image
image1009×463 3.99 KB

I just want to aggregate all similar values. can you help me with SQL Script?

2

please provide your sample data not as an image (we cannot query an image) but as proper DDL and DML

create table #sample(code int, description nvarchar(10))

insert into #sample
Slect 0, 'AAA' union
select 1, 'BBB'

for the whole data set

3

Hope this helps

select 
   description , count(*) 
from 
  TABLE
group by 
  description

image

4

Sorry seems like I was not clear. What I want to do is not something pivot table does in excel. I actually have a big table in database and what I want to do is to get to know what are all different values possible for a code for example or at least all the available values in the table. When I do not know what are the possible value I cannot find the related table that has those values stored in it.

5

Maybe?:

SELECT DISTINCT code, description
FROM table_name
ORDER BY code, description