select count(*) / count(*) ???
(메가존)곽지은
Hello. Please let me know if you have a good way.
---------------------------------------------------------------------------------------------------
NumberPath<Long> count1 = Expressions.numberPath(Long.class, “count1”);
NumberPath<Long> count2 = Expressions.numberPath(Long.class, “count2”);
NumberPath<Long> count3 = Expressions.numberPath(Long.class, “count3”);
JPQLQuery<OnlineTrainingCourseDto> query = getQuerydsl().createQuery()
.select(
new Dto(
ExpressionUtils.as(
JPAExpressions.select(table2.table2Seq.count())
.from(table2)
.where(table2.table2Seq.eq(table1.table1Seq)),
count1
),
ExpressionUtils.as(
JPAExpressions.select(table2.table2Seq.count())
.from(table2)
.where(table2.table2Seq.eq(table1.table1Seq)
.and(table2.table2Yn.eq(true))),
count2
),
????? count1 / count2 as count3 ?????
)
)
)
.from(table1)
---------------------------------------------------------------------------------
I want the query below. What should I do? plz...
select
(select count(*) from table2 where table2.table2Seq = table1.table1Seq) as count1,
(select count(*) from table2 where table2.table2Seq = table1.table1Seq and table2Yn = true) as count2,
(select count(*) from table2 where table2.table2Seq = table1.table1Seq) / (select count(*) from table2 where table2.table2Seq = table1.table1Seq and table2Yn = true) as count3
from
table1
order by
count3