Alternative of executing same sql query again with different parameters

Question

I need to do the following :

select table1.abc from table1 where col1 = ? and col2 = ?

The problem here is i need to get data from this table for 3 sets of (col1, col2). I don't want to execute the same query 3 for different parameters.

Also i want to have the result set of the executed query containing 3 columns of data (1 for each set of col1,col2).

Let me know if any further details are reqd.

What database are you using? The answer could change based on the platform. :) — bhamby
– bhamby, Commented Aug 29, 2012 at 16:12
Is there only one row in the result of your query? And what is the datatype of table1.abc? — lc.
– lc., Commented Aug 29, 2012 at 16:14

lc. · Accepted Answer · 2012-08-29 16:18:12Z

1

You can just use subselects if there's only one result for your query:

select (select table1.abc from table1 where col1 = ? and col2 = ?),
    (select table1.abc from table1 where col1 = ? and col2 = ?),
    (select table1.abc from table1 where col1 = ? and col2 = ?)
from table1
limit 1

answered Aug 29, 2012 at 16:18

lc.

117k21 gold badges164 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Niroshan Over a year ago

Could you comment on efficiency of this over the other? Are there any plus points?

Ilmari Karonen · Accepted Answer · 2012-08-29 16:55:58Z

1

You can use OR clause with 3 sets having different parameter set

select table1.abc from table1 where (col1 = ? and col2 = ?)
OR (col1 = ? and col2 = ?) OR (col1 = ? and col2 = ?)

edited Aug 29, 2012 at 16:55

Ilmari Karonen

50.5k9 gold badges96 silver badges156 bronze badges

answered Aug 29, 2012 at 16:46

sqlhdv

2541 silver badge7 bronze badges

1 Comment

Rachit Agrawal Over a year ago

this would return three rows..but i need only 1 row in result set but 3 columns in that row

Collectives™ on Stack Overflow

Alternative of executing same sql query again with different parameters

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related