I have a table Product with So i need a select query that will display distinct product no with ids for displaying in p-listbox. say How do i achieve this? Thanks Answer One method is: That said, I would probably use group by:

select distinct and autoincrement field in select query

I have a table Product with

ProductNo ProductDetail UniqueiD(Primarykey)
L1234      ProductA        1
L1234      ProductB        2
L1234      ProductC        3
M1234      ProductD        4
M1234      ProductE        5

​x
 
ProductNo ProductDetail UniqueiD(Primarykey)L1234      ProductA        1L1234      ProductB        2L1234      ProductC        3M1234      ProductD        4M1234      ProductE        5​

So i need a select query that will display distinct product no with ids for displaying in p-listbox. say

Name  code
L1234  1
M1234  2

 
Name  codeL1234  1M1234  2​

How do i achieve this? Thanks

Answer

One method is:

select distinct name, dense_rank() over (order by name)
from product;

 
select distinct name, dense_rank() over (order by name)from product;​

That said, I would probably use group by:

select name, row_number() over (order by name) as code
from product
group by name;

 
select name, row_number() over (order by name) as codefrom productgroup by name;​

Advertisement

Answer