Having issue with script running query

[Robert Walton]

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?

[Dibyandu Roy]

Use return to view it. 

For eg:

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

return query_output 

[Robert Walton]

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