pattern matching - How to display this: row pair - column a value of one row is in column b of row 2 and column a value of second row is in column b of first row oracle? -


i have table of bus details. has bus_name, bus_source , bus_destination. need know bus pairs make return journey possible. eg.

  bus_name | bus_source | bus_destination            | chennai    | bangalore     b      | bangalore  | chennai     c      | mumbai     | chennai

i expect this:

  bus_name | bus_source | bus_destination          | chennai    | bangalore     b      | bangalore  | chennai

use exists() :

select * yourtable t exists(select 1 yourtable s              t.bus_source = s.bus_destination                , t.bus_destination = s.bus_source);

Comments

Post a Comment

Popular posts from this blog

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

kendoui grid detail template -

in master of kendoui grid use code create style budget column $budgetcolumn = new \kendo\ui\gridcolumn(); $budgetcolumn->field('budget') ->width(120) ->template('<div class="textright"> #= kendo.tostring(budget, "n") # </div>') ->format('{0:n}') ->title('budget'); i can't create style @ row installment code in detail grid template $installmentcolumn->field('installment') ->width(120) ->template('<div class="textright"> #= kendo.tostring(installment, "n") # </div>') ->format('{0:n}') ->title('budget'); how create style on grid details because can not use same technique
Read more