| Author | Message | ||
     Komaranna Side Hero Username: Komaranna Post Number: 3059 Registered: 07-2010 Posted From: 12.34.246.73 Rating: N/A |
help sesthe seyandi lekunte enduku free adivse ee akulu db or vatta ani...hot seat lo kukunte erukna g neppi | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 4285 Registered: 02-2010 Posted From: 166.137.88.44 Rating: N/A |
if u know schema u can try this select a.ssn,b.ccdbid from schema.TableA a, schema.TableB b where a.ssn=b.ssn e way lo try karo ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Python Comedian Username: Python Post Number: 1509 Registered: 08-2012 Posted From: 59.92.180.204 Rating: N/A |
15 years ninsi job chesina cheyyaka poyina .. db'ing sestunnav .. db sql queries meeda posts eyyatame kakunda ... peda vadu anta malla sentiment pending ... nuvvu dabbu ki pedha kadhu OT... tech ki pedha ... Properly trained, a man can be a dog's best friend | ||
| Netsaint Side Hero Username: Netsaint Post Number: 6389 Registered: 05-2008 Posted From: 171.159.64.10 Rating: N/A |
maa byanki lo raase stored procs, sqls ki Millions records untai. avi updates etc run authey, hours padthadi... so every millisec is so important for server resources(sql). so tables ki neat ga primary keys etc, lantivi lekunte, avi ethiki ethiki update cheskuntundi, adhey neat ga goood design chesunte, simple ga line lo nilchobetti khaima kodthundi . so all the time/resources/cpu load it takes anntha kalipi COST antaru My Telugu Bhakthi Blog :http://gurugeetha.blogspot.com/ | ||
| Driverramudu Side Hero Username: Driverramudu Post Number: 8571 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
aa dielaag tho oka madhala rangaravo oka erra sainyam narayana murthi gaaru yaad ki vassar  Life is Race. I am in. Driving is my PASSION. Chakkani Car undi Pakkana Pilla undi  | ||
| Netsaint Side Hero Username: Netsaint Post Number: 6388 Registered: 05-2008 Posted From: 171.159.64.10 Rating: N/A |
general ga ssn lanti field chala distuinguish cheyyadaniki vaadutharu. its like central hub for all types of queries which is itself so unique. so ssn lanti field update authey(like u can have a new ssn, everything remains same), appudu normalisation lekunte, dooools teeers as it has to get updated at so many places. so simple ga single simham type lo , undi, update avuthey motthaniki latest unique ga untadi My Telugu Bhakthi Blog :http://gurugeetha.blogspot.com/ | ||
| Amara Side Hero Username: Amara Post Number: 5771 Registered: 09-2010 Posted From: 27.6.148.203 Rating: N/A |
mee mail id pettandi basics pampistha..db'ing thagginchi chadavandi...easy u know. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108713 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
kiki...nenu feel ayyaanu anukoni nuvvu feel ayyavu  nenu feel avadam endhi kamedy gaa...njoy...goodnight | ||
| Driverramudu Side Hero Username: Driverramudu Post Number: 8570 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
jovial ga anna feel aire sworry  Life is Race. I am in. Driving is my PASSION. Chakkani Car undi Pakkana Pilla undi | ||
| Chitti_babu Side Hero Username: Chitti_babu Post Number: 2965 Registered: 03-2012 Posted From: 173.89.6.116 Rating: N/A |
Chicago lo...evaranna SQL expert ayina DB er ni intiki pilivu....ayana chethilo nee system etti...nuvvu eelopu DB ing cheyyi... | ||
| Mahesh_fan Side Hero Username: Mahesh_fan Post Number: 7934 Registered: 09-2010 Posted From: 207.255.49.43 Rating: N/A |
enjoy macha Disclaimer : Videopod.in site is mine. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108712 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
next minute  | ||
| Mahesh_fan Side Hero Username: Mahesh_fan Post Number: 7933 Registered: 09-2010 Posted From: 207.255.49.43 Rating: N/A |
online screen sharing apps . Disclaimer : Videopod.in site is mine. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108711 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
peda vaadi bathuku poratam bhuswamulaki kamedy gane untundhiii | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108710 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
nope...no installation rights to anyone | ||
| Mahesh_fan Side Hero Username: Mahesh_fan Post Number: 7932 Registered: 09-2010 Posted From: 207.255.49.43 Rating: N/A |
gotomeeting skype install cheyaleva Disclaimer : Videopod.in site is mine. | ||
| Driverramudu Side Hero Username: Driverramudu Post Number: 8568 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
hemtiva hinta sinna sinna queries ki ilaa settava DB lo logics tala pandina politc analyst vi chasss Life is Race. I am in. Driving is my PASSION. Chakkani Car undi Pakkana Pilla undi | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108709 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
outgoing email access ye ledhu ...inka remote login...access...kiki | ||
| Chitti_babu Side Hero Username: Chitti_babu Post Number: 2963 Registered: 03-2012 Posted From: 173.89.6.116 Rating: N/A |
Remote login ayyi......DB lo evarikanna system, db access/sharing ivvu... Query raasi, execute chesi, result set neeku chethilo pedathaaru... | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 4283 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
t1 anedi table obj la vadutaru general ga...like t1.columnName select * from Table1 t1 where t1.ssn =1112211 ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Gandhiguevara Legend Username: Gandhiguevara Post Number: 34282 Registered: 10-2009 Posted From: 98.197.251.182 Rating: N/A |
My gawd...yee thread ippude choosa...is it really happening...I think Ashton is right...may be Dec 21st 2012 is Go Live date | ||
| Gandhiguevara Legend Username: Gandhiguevara Post Number: 34281 Registered: 10-2009 Posted From: 98.197.251.182 Rating: N/A |
 | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108708 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
mee query lo aa t1 enti ?
confusion ledhu gaani..last help : query 3 tables ki expand seyyandii.. | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11911 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
18 rows lo ee row kavali anedi telavali dani batti row_number pettali i selected entrydate in table2 assuming a person has been in 18 places and last address is at 18th row in table 2 for ssn1 same thing with table 3 and table 4 sometimes using max, min functions when u have more than 1 row but it all depends on what u want to be pulled in one row for ssn1. nenu confuse chestunna ante better ask team mates... Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108707 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
Mexican vadiki sanskrit slokam cheppinattu undhi...sarE will try this.. | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11909 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
looks like db2 has row_number() function too http://www.ibm.com/developerworks/data/library/techarticle/d m-0401kuznetsov/index.html so try below query i gave on two tables one with 18 rows clean extra comma and other stuff in query... and build 2 other sub queries and complete final query Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Buduguuu Side Hero Username: Buduguuu Post Number: 8191 Registered: 01-2012 Posted From: 108.71.198.199 Rating: N/A |
underlying ga databse cost ni ela calculate chestado naku telvadu. but the effeciency of your query can be known by the cost of th query raaboye kaalaniki kaaboye mod ni.. b careful with me | ||
| Buduguuu Side Hero Username: Buduguuu Post Number: 8190 Registered: 01-2012 Posted From: 108.71.198.199 Rating: N/A |
simple ga aite the best way DB chooses to execute your query is the one with less cost. manam raase query ni optimizer ani okati untadi. adi ee query ye way lo execute cheste less time teesukuntadi ani decide chestadi. less time is proportionate to the cost of the query(though not always but majority times) select * froma,b, where a.column1 = b.column1 and b.column= c.column1 ani undi. a.column1 meeda index undi b.column meeda index undi when you execute this query, optimizer will see 1.what is the cost if the indexes are included 2.what is the cost if the indexes are not included ee cost ni calculate cheyyadaniki chala parameters untai. like joins involved, indexes on the join columns, number of records in the table, how frequently are they changing etc etc raaboye kaalaniki kaaboye mod ni.. b careful with me | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11907 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
simple ga if you have two tables table1, ssn (1 row) table 2 ssn, address, entrydate fields (18 rows) 1, a1, day1 1, a18, day18 output 1, a18, d18 SELECT SSN, address FROM (SELECT ROW_NUMBER() OVER ( PARTITION BY SSN ORDER BY entrydate DESC ) AS 'RowNumber', SSN, address, FROM table1 left outer join tabl2 on table1.ssn=table2.ssn ) t1 WHERE RowNumber <= 1 as i said google equivalent query for Db2, i think row_number equivalent is rank or something Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Megastar Username: Twitter Post Number: 22879 Registered: 10-2009 Posted From: 69.126.240.223 Rating: N/A |
Cost ante over head on server ani in terms of time resources etc due to lack of proper design/index/referrences etc | ||
| Buduguuu Side Hero Username: Buduguuu Post Number: 8189 Registered: 01-2012 Posted From: 108.71.198.199 Rating: N/A |
simple unkel.. reduce the redundant data.. ssn apply chesinappudu oka address untadi he changes place, so he updates new address. adress table will still have both the address with the new address being active and old address inactive. just example scenario ga ichanu. idanta oka table lo edte ssn data is redundant raaboye kaalaniki kaaboye mod ni.. b careful with me | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108706 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
thread lo thress persons used this...query cost ante hemiti ? | ||
| Casino Comedian Username: Casino Post Number: 1611 Registered: 01-2012 Posted From: 69.115.50.18 Rating: N/A |
select count(*) from a where ssn = '111-11-1111' and do the same for all the tables... i think one of your tables will return 18 rows or the product of all the counts that you get from the above query will be 18 ... | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108705 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
tables soodagane na sitti burra ki adhe doubt vachindhi...single ssn ki inni tables endukura bujji ga anni oke daantlo toeseyyochu ga ani....kaani ee peddhollunnare ilaa design jesarante edho balamaina karanam undi untundhile adigi ep lu avvadam enduku ani alaage batting sesthunnaa | ||
| Buduguuu Side Hero Username: Buduguuu Post Number: 8188 Registered: 01-2012 Posted From: 108.71.198.199 Rating: N/A |
1. as long as the cost of the query is less and indexes are properly defined on the columns in join conditions, it should be good. 2. Most of the data in these 5 tables is static and not huge. raaboye kaalaniki kaaboye mod ni.. b careful with me | ||
| Casino Comedian Username: Casino Post Number: 1610 Registered: 01-2012 Posted From: 69.115.50.18 Rating: N/A |
future lo malla thread esinappudu chustano ledho... my detils to your database '111-11-1111', 'Ennare', 'Stamford', '06901', 'Casino', 0, 'kapu', 'Congress'... btw, my 2 cents for your db.. don't split the information into multiple tables.. especially with the data you are storing there is no need for normalization.. use just one table sir. cost / efficiency antara, meeru vokka table ee information pedithe record ekkadunna nimasham lo bitaki vasthadhi.. ee join la valla thokka lo locks/isolation levels voka saari chadavandi | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108704 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
A2J mama, nee music edho nenu face chesina music ki matching matching...reference links, idhi seyyi ani seppakundaa....fls gimme direct query for below scenario: My query : A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party where a.ssn = b.ssn and b.ssn = c.ssn and a.ssn = d.ssn where a.ssn = '111-11-1111' scenario 1 : one SSN returned a single row since all 4 tables have relevant data - NO ISSUE - scenario closed scenario 2 : another SSN returned NO rows, just becoz one of the tables has no entry of that SSN.... ee thread lo solution icharu - scenario closed scenario 3 : one SSN returned 18 rows...dunno why ! most probable root cause is it has multiple addresses in just one of the four tables .. solution query pls | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11906 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
distinct vadithe saripodu or panicheyadu. it works if 18 rows in table 2 have same data which is not true in reality. Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108703 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
ok,will try
posani krishna murali ki aishryarai andaanni xplain seisinattu naaku predicates,costly antarenti mastaaru  | ||
| Netsaint Side Hero Username: Netsaint Post Number: 6387 Registered: 05-2008 Posted From: 171.159.64.10 Rating: N/A |
select Distinct(A.SSN) as SSN, My Telugu Bhakthi Blog :http://gurugeetha.blogspot.com/ | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108702 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
after abcdefg post i recollect one more... same query that was posted in first post select A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party where a.ssn = b.ssn and b.ssn = c.ssn and a.ssn = d.ssn where a.ssn = '111-11-1111' adhi 18 rows return sesindhi okasari....details dig jeyyaledhu... one row ye ga return seyyalsindhi ...what went wrong ? and how to deal future cases ? | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11905 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
life just one sql tho ayipothe manani enduku hire chestaru... table1 ni table 2 join chesinappudu rownumber based on ssn and secondtable create cheyali atta rest 2 tables tho chesukonta ellali. it depends on what row in second table kavalo create cheyali... last entered address aa edo oka row_number sort cheyali... DB2 lo aiyte google lo search "db2 sql to get top rows in a group" or something try cheyi. 111-111-1111, address1 111-111-1111, address2 111-111-1111, address3 using rank or row_number() in sql to create and limit top 1 row or your criteria ex: http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx ?title=SelectTopNByGroup Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Chitti_babu Side Hero Username: Chitti_babu Post Number: 2962 Registered: 03-2012 Posted From: 173.89.6.116 Rating: N/A |
"Neeku emaina vaccha?" ani adiguthunnava enti | ||
| Nexuss Junior Artist Username: Nexuss Post Number: 152 Registered: 04-2011 Posted From: 74.63.112.145 Rating: N/A |
Add distinct to the query. NOTE: If you use predicates, your query will be costly.. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108701 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
neeku emaina telusa ? | ||
| Agniparvatham Side Hero Username: Agniparvatham Post Number: 3247 Registered: 01-2008 Posted From: 173.61.128.77 Rating: N/A |
 | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108699 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
superr...inko instance gurthochindhi... oka ssn 18 rows return jesindhi ....denemma gola...forgot to ask.. aa 4 tables lo ekkadaina oka table lo two rows unte entire values twice vstunnayi how to deal two addresses scenario ? oke row return ravali.... | ||
| Abhysg Side Hero Username: Abhysg Post Number: 7047 Registered: 08-2008 Posted From: 68.39.93.169 Rating: N/A |
OT cheppina criteria ki SQL kashtam..anukonta unless you know one master table must have all entries of SSN.. egasperts correct seyyandi no siggy | ||
| Megastar Username: Twitter Post Number: 22872 Registered: 10-2009 Posted From: 69.126.240.223 Rating: N/A |
4096 limit undhi em parledh kummei | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 11903 Registered: 02-2007 Posted From: 76.226.180.207 Rating: N/A |
below query with left outer join works but as long as each ssn has one row or less in all other tables (b, c) is it ok for you to get 2 rows of address for person 1? you might have to use subqueries or rowid's to limit one row per ssn ex: table 1 is person tabl2 is address if one person has two addresses below query with outer will give 2 rows per person Ravino: jail antava gandhi kuda welladu adhe bata lo jagan anna | ||
| Dma Side Hero Username: Dma Post Number: 6821 Registered: 11-2009 Posted From: 64.134.236.246 Rating: N/A |
main frame lona? unix lona? DB2 ayite nenu jump. pai question is for clarifying others. | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 4274 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
OT, dbtools untayi...visual gui, mean if u dont want take risk at all, just drap and drop, join...done deal. ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Ntr_rocks Moderator Username: Ntr_rocks Post Number: 39071 Registered: 04-2009 Rating: N/A |
This DB needs better class of Hater, Pyscho and Sadist. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108696 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
DB2 | ||
| Jumbojet Junior Artist Username: Jumbojet Post Number: 923 Registered: 12-2011 Posted From: 24.2.208.145 Rating: N/A |
| ||
| Ntr_rocks Moderator Username: Ntr_rocks Post Number: 39069 Registered: 04-2009 Rating: N/A |
neeku cheppe antha age, experience ledu kaani... Konni emi cheyalem...Depends on the client data model...Mari old data model vundi daaniki patches esi yrs ala naduputunnar anuko, tappadu... Cheppindi tappaithe kshemincheyi.. This DB needs better class of Hater, Pyscho and Sadist. | ||
| Dma Side Hero Username: Dma Post Number: 6818 Registered: 11-2009 Posted From: 64.134.236.246 Rating: N/A |
Syntax is different for each database. em database vaaduthunnavu? | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 4271 Registered: 02-2010 Posted From: 67.163.149.59 Rating: |
dont query the query otherwise the qUery will query you...I am not a querier i am a sql developer.. ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Chitti_babu Side Hero Username: Chitti_babu Post Number: 2960 Registered: 03-2012 Posted From: 173.89.6.116 Rating: N/A |
Icchindhi teesuko.........vallani test cheyyaku... | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108693 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
mastaaruu...technically query entha podugainaa alaaaaaaaa alaa vellipovachaa ? is it good frogramming fractice if i pull 380 values at a time from 5 tables ?? | ||
| Ntr_rocks Moderator Username: Ntr_rocks Post Number: 39068 Registered: 04-2009 Rating: N/A |
 This DB needs better class of Hater, Pyscho and Sadist. | ||
| One Hero Username: One Post Number: 16001 Registered: 09-2008 Posted From: 173.242.124.71 Rating: N/A |
adey chesadu kadha ..... | ||
| One Hero Username: One Post Number: 16000 Registered: 09-2008 Posted From: 173.242.124.71 Rating: N/A |
last week oka query meda work chesi vundey ..... 16 lines query ..16 tables ....2 days patindi oka shape ku ravataniki | ||
| Sachin Legend Username: Sachin Post Number: 31308 Registered: 04-2008 Posted From: 71.168.42.76 Rating: N/A |
full outer join enduku....just left outer join saripodddi share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Outlaw Comedian Username: Outlaw Post Number: 1412 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
sesuko. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108688 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
so..ne query...not only C table ..but any table lo data lekapoina rest three vi return setthadhi kadhaa...lock sesukonaa ! THANKS TO ALL | ||
| Seenu454 Side Hero Username: Seenu454 Post Number: 8181 Registered: 03-2008 Posted From: 68.32.38.26 Rating: N/A |
Annai  Just4fun ----- Rajareddy appatlone BIG FARMER. vandala acres farming lands undevi rajusk ---- telisina ventane avi vapas ichesaru..endukante avi Assigned lands kabatti | ||
| Outlaw Comedian Username: Outlaw Post Number: 1411 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
one reddy garu  | ||
| One Hero Username: One Post Number: 15996 Registered: 09-2008 Posted From: 173.242.124.71 Rating: N/A |
nee yenkamma..google best friend vi ..ilanti china query ki kuda thread na | ||
| Megastar Username: Twitter Post Number: 22870 Registered: 10-2009 Posted From: 69.126.240.223 Rating: N/A |
ot ee + lu - tho conpuse kaaku if it is plain SQL just use literal that is very simple .. | ||
| Outlaw Comedian Username: Outlaw Post Number: 1410 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
annai meeru vunnaru ani teliyaka edo tosina answer seppesanu manninsagalaru  | ||
| Megastar Username: Twitter Post Number: 22869 Registered: 10-2009 Posted From: 69.126.240.223 Rating: N/A |
ehe jhest out line icchha theeskelli compile seyyamani kadhu uzles OT ki aa maathram theldheti | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108685 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
entaa soopu...SQL dead eeek ikkada | ||
| Outlaw Comedian Username: Outlaw Post Number: 1409 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
Correction 1&2 . select A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party from a Full Outer join b on a.ssn = b.ssn full outer join c on a.ssn =c.ssn full outer join d on a.ssn = d.ssn where a.ssn = '111-11-1111' | ||
| Seenu454 Side Hero Username: Seenu454 Post Number: 8180 Registered: 03-2008 Posted From: 68.32.38.26 Rating: N/A |
 Just4fun ----- Rajareddy appatlone BIG FARMER. vandala acres farming lands undevi rajusk ---- telisina ventane avi vapas ichesaru..endukante avi Assigned lands kabatti | ||
| Outlaw Comedian Username: Outlaw Post Number: 1408 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
u twitter vankle u fail uzeless where are the B,C,D table names I say. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108683 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
denilo miss avutundhO manaki mundhu teliyadhu ee case lo.....so still nuvvu,outlaw seppina query yenaa ? | ||
| Outlaw Comedian Username: Outlaw Post Number: 1407 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
1&2 . select A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party from a inner join b on a.ssn = b.ssn left outer join c on a.ssn =c.ssn left outer join d on a.ssn = d.ssn where a.ssn = '111-11-1111' | ||
| Megastar Username: Twitter Post Number: 22868 Registered: 10-2009 Posted From: 69.126.240.223 Rating: N/A |
assuming atleast Table A has SSN always , this will do Select A.SSN, A.LName, B.Address,c.posts_count,D.cast from A Left outer join on A.SSN=B.SSN Left outer join on A.SSN=C.SSN Left outer join on A.SSN=D.SSN Where A.SSN='xxx-xx-xxxx' | ||
| Buduguuu Side Hero Username: Buduguuu Post Number: 8187 Registered: 01-2012 Posted From: 108.71.198.199 Rating: N/A |
denilo datamiss avtunnado dani pakkana (+) etteyandi simple. record lekapote null stamp chestadi akkada raaboye kaalaniki kaaboye mod ni.. b careful with me | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108681 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
ante ?
exflain fleez | ||
| Outlaw Comedian Username: Outlaw Post Number: 1406 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
1.ANSI koncham faster vuntadi emo. 2. A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party where a.ssn(+) = b.ssn and b.ssn(+) = c.ssn and a.ssn(+) = d.ssn where a.ssn = '111-11-1111 edo midi midi gnanam to seppanu vadiley tappu aithe. | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108680 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
adhe baaboooooo.....vaadi aa query ni cheppandi...naaku raadhu | ||
| Andhrawala Hero Username: Andhrawala Post Number: 14636 Registered: 03-2008 Posted From: 174.97.225.181 Rating: N/A |
Outer join vaaduthaavu Jgamerigina brhamnudiki jandhyamelaa annattugaa kochen nuvve seppesi anaswer koodaa nuvve seppesevu ee thead lo ardham paramaardham emanna vundhaaa No Signature | ||
| Outlaw Comedian Username: Outlaw Post Number: 1405 Registered: 02-2012 Posted From: 65.24.98.37 Rating: N/A |
Denilo fact table edi? | ||
| Onlytruth Legend Username: Onlytruth Post Number: 108677 Registered: 01-2007 Posted From: 98.226.57.134 Rating: N/A |
OkE person details ilaa multiple tables lo untaayi anukondi,needless to say SSN is the common/unique item interlinks persons' details. Table A : Fields : SSN, FName, LName ,MName Table B : Fields : SSN, Address1, Address2, PhNum,Zip Table C: Fields : SSN,ccdb id,posts_count, bannedcount Table D: Fields : SSN, Party , caste, H1/GC Now...i want to return a single person details ONLY THESE : ssn,Lname,address2,zip,ccdbid,posts_count, caste,party single recordset return jeyyaali oke line lo My query is : A.SSN,A.Lname,B.address2,b.zip,c.ccdbid, c.posts_count,D.Caste,D.Party where a.ssn = b.ssn and b.ssn = c.ssn and a.ssn = d.ssn where a.ssn = '111-11-1111' question 1 : Is there any better/efficient query ? question 2 : If one of those tables do not have pertaining values.. rest of the tables data is also NOT returning values...i.e for e.g. aa person ki ccdb lo ID ye ledhu anukondi obvious ga atani record Table C lo undadhu...Table C lo just SSN undi migilina values NULL undadam KAADHU...asalu SSN entry kuda undadhu......so....adanna maata.... A,B,C,D llo ye table(s) lo assalu entry ye lekapoinaa rest table(s) nunchi data vacheyyaali...left join kind of use jeyyali ani ardham aitandhi gaani...opika ledhu...veasy ga seppandi |
