JMeter JDBC Sampler extract more than one column values

Question

I have a sql like the following in JDBC Sampler of JMeter

select id,code from table where .....

how do I extract the value of the two columns.

Answer 1

Are you asking how to extract a value from the response?

If so, use the post-processor "regular expression extractor", attached to the JDBC request.