1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Not getting the correct results after querying,plz help!

Discussion in 'Databases' started by apprentice, Feb 11, 2007.

0
  1. #1
    Hi frens,

    Need your expertise to help solve the below sql problem.Im having problem to add another condition inorder for me to get 3 lines (highlighted in blue in the excel sheet attachment).At the moment I'm only getting 2 lines using the below sql.Tried various ways but wid no luck.Please help.

    select * from fwcatns_testbintxn where bintype ='R' and bincategory ='H' and
    step like 'T-ET%' and activity like '%YieldCheck%'and
    lottxncounter = (select max(lottxncounter)
    from fwcatns_testbintxn
    where lotobject = '00000e31.24050a80.4302b173.0011344b.5452')
     

    Attached Files:

    • sql.xls
      File size:
      18 KB
      Views:
      103
    apprentice, Feb 11, 2007 IP