Subquery
left parenthesis in new line
gFmtOpt.Subquery_NewlineBeforeLeftParentheses
boolean
default: true
right parenthesis in new line
gFmtOpt.Subquery_NewlineBeforeRightParentheses
boolean
default: true
indent size for right parenthesis(according to left parenthesis)
gFmtOpt.Subquery_IndentRightParentheses
integer
default: 0
select keyword in new line
gFmtOpt.Subquery_NewlineBeforeSelect
boolean
default: true
indent select keyword
gFmtOpt.Subquery_IndentSelect
integer
default: 2
align subquery with parent expr
gFmtOpt.Subquery_AlignWithExpr
boolean
default: false
SQL before beautify
select pic_id,pic_name,path
from pic_info a
where pic_id = (
select top 1 pic_id
from pic_info b
where b.pic_category = a.pic_category
order by pic_date desc
)
SQL after beautify
SELECT pic_id,
pic_name,
PATH
FROM pic_info a
WHERE pic_id =
(
SELECT TOP 1 pic_id
FROM pic_info b
WHERE b.pic_category = a.pic_category
ORDER BY pic_date DESC
)