Having issue with script running query

Question

I am creating a scriptrunner script to query a db table and return a row. How do i access the result row which has only one column in it?

Robert Walton_hi23a7 · Answer

Here is my code

def sSql = "select Grouping from options where Segment = ${sSegment} and Service = ${sService}"
row = sql.firstRow(sSql) { }

Not sure if i got the syntax correct

Dibyandu Roy · Answer

Use return to view it.

For eg:

def query_output = <syntax and query to be executed on db>

return query_output