Column name as a query parameter Spring JPA

Asked Mar 28 '22 at 12:29

Active Mar 28 '22 at 12:42

Viewed 38 times

I am using Spring JPA for show all duplicates in column or only unique values in colums. But I have many columns and need choose the columns. In Postgres I use query:

SELECT * FROM table_test ou WHERE 
(SELECT COUNT(*) FROM table_test inr WHERE inr.col1 = ou.col1) > 1;

Repository:

    @Query(value = FIND_DUPLICATES, nativeQuery = true)
    List<Product> findDuplicates();

But need change name of column (@Param). I tried:

SELECT * FROM table_test ou WHERE 
(SELECT COUNT(*) FROM table_test inr WHERE inr.?1= ou.?1) > 1;

doesn't work.

edited Mar 28 '22 at 12:42

asked Mar 28 '22 at 12:29

mszyba

See : https://chartio.com/learn/databases/how-to-find-duplicate-values-in-a-sql-table/ – Maxim Bezmen Mar 28 '22 at 12:46
@NikolaiShevchenko yes and no. My value is only columnName in query. Here I see columnsName and value what I need to find. Or I can't implementation it. – mszyba Mar 28 '22 at 13:06
You can't pass column **names** as parameters. Parameters are only for **values**. – Mark Rotteveel Mar 29 '22 at 13:25

Column name as a query parameter Spring JPA

0 Answers0