SQL subquery invalid in the select list -

-

i working on below code recursively same table getting error

*column 'checkinout.userid' invalid in select list because not contained in either aggregate function or group clause.*

*column 'checkinout.checktime' invalid in select list because not contained in either aggregate function or group clause.*

select convert(varchar,checktime, 106) gatedate, convert(varchar,checktime, 106) gatein ,(     select top 1 convert(varchar(5),ch001.checktime, 108)      checkinout ch001     checktype ='i'          , ch001.userid= mm001.userid            ,          (convert(varchar, ch001.checktime, 112) =convert(varchar, mm001.checktime, 112)) ) timein   checkinout mm001 userid=@empid 

select convert(varchar,checktime, 106) gatedate, convert(varchar,checktime, 106) gatein ,(     select top 1 convert(varchar(5),ch001.checktime, 108)      checkinout ch001     checktype ='i'          , ch001.userid= mm001.userid            ,          (convert(varchar, ch001.checktime, 112) =convert(varchar, mm001.checktime, 112)) ) timein   checkinout mm001 userid=@empid group checkinout.userid, checkinout.checktime

Comments

Post a Comment

Popular posts from this blog

c - CUDA code not processing if block properly -

-
stuck @ if block right below //step 5, issue code not progress or after given if block. need figure out how particular issue settled before starting task of generating parallel code. if run code see 1 print statement indicates value of "one" , 2 "i" , "j". after if block begins, none of other print statements hit. result quite stuck, aware specific issue, however, cannot seem determine it's cause. any appreciated! in advance! input file sample. >386.fasta.screen.contig1 gagtttgatcctggctcagaatcaacgctggcggcgcgcttaacacatgc aagtcgaacgagaaagtggagcaatccatgagtacagtggcgtacgggtg agtaacacgtgggtaatctacctcttagtggggaataactttgggaaacc gaagctaataccgcataagctcgagagaggaaagcagcaatgcgctgaga gaggagcccgcggccgattagctagttggcagggtaaaagcctaccaagg cagagatcggtagccggcctgagagggcacacggccacactggcactgaa acacgggccagactcctacgggaggcagcagtggggaatcttgcacaatg ggggcaaccctgatgcagcgacgccgcgtgagcgatgaagcccttcgggg tgtaaagctctttcgtcagggaagatagtgacggtacctggagaagcagc tgcggctaactacgt...
Read more

Android Capture Image From Camera -

-
i making application in i'm using camera function of android. i'm opening camera , taking picture.in simple way easy do. but want take picture camera when user touch on anywhere on opened camera screen. (like use focus functionality) thank in advance , sorry bad english.
Read more

oracle11g - get root domain from url Oracle sql regex_substr -

-
i have query root domain urls below : select regexp_substr(regexp_replace('https://creditcards.chase.com/credit-cards/bp-credit-card.aspx', '^http[s]?://(www\.)?|^www\.', '', 1), '(\.\w+)+') domain dual; which returns out put : '.chase.com' how can ignore first dot in outoput regex in above query? note : need root domain, i.e, 'chase.com' thanks. select regexp_substr('https://creditcards.token.chase.com/credit-cards/bp-credit-card.aspx', '(^http[s]?://(www\.)?|^www\.)(\w+\.)*(\w+\.\w+)', 1, 1, 'i', 4) domain dual;
Read more