/SQL/Save single sql query result boolean spring boot

Save single sql query result boolean spring boot

@Repository
public interface CompanyRepository extends JpaRepository<Company, Integer> {
    @Query("SELECT CASE WHEN COUNT(c) > 0 THEN true ELSE false END FROM Company c WHERE c.name = :companyName")
    boolean existsByName(@Param("companyName") String companyName);
}

Source: codingexplained.com

Similar codes

11 votes218 views2 answers
Oracle saurce code
SQL
0 vote224 views2 answers
While mysql
SQL
0 vote219 views1 answer
Mysql last friday of current month
SQL
0 vote171 views1 answer
Query for maximum salary
SQL
0 vote213 views1 answer
Mariadb current date plus 1 day
SQL
1 vote218 views1 answer
Declare table variable
SQL
0 vote197 views1 answer
Postgre admin slow
SQL
23 votes211 views4 answers
How to uninstall postgresql in ubuntu
SQL
10 votes218 views2 answers
SQL rounding numbers
SQL
0 vote278 views1 answer
Python get backup of sql
SQL