SQL Queries practice thread

[Guest]

queries ena [img]http://www.myfda.org/wp-content/uploads/2009/06/acne-scars-collagen-injections.jpg[/img] levaa s%H#

[maaditenali]

[quote author=        link=topic=201842.msg2464913#msg2464913 date=1307897370]
queries ena [img]http://www.myfda.org/wp-content/uploads/2009/06/acne-scars-collagen-injections.jpg[/img] levaa s%H#
[/quote]

@3$% @3$% @3$% @3$% @3$% CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# CITI_$D# sql- injections gurinchi kavaala??

[king420]

[quote author=        link=topic=201842.msg2464913#msg2464913 date=1307897370]
queries ena [img]http://www.myfda.org/wp-content/uploads/2009/06/acne-scars-collagen-injections.jpg[/img] levaa s%H#
[/quote] s%H# s%H# s%H# sSa_j@il sSa_j@il sSa_j@il

[maaditenali]

sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y[quote author=HAPPYNESS link=topic=201842.msg2464923#msg2464923 date=1307897600]
s%H# s%H# s%H# sSa_j@il sSa_j@il sSa_j@il
[/quote]

[Guest]

[quote author=GAJADONGA GANGULU link=topic=201842.msg2464925#msg2464925 date=1307897647]
sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y
[/quote]injection anagane ekkada back lo podustaremo chinnapatila ani dakkunattunadu aa baa

[maaditenali]

@3$% @3$% @3$% @3$% @3$% @3$%[quote author=        link=topic=201842.msg2464930#msg2464930 date=1307897733]
injection anagane ekkada back lo podustaremo chinnapatila ani dakkunattunadu aa baa
[/quote]

[sombarey]

*=: *=: *=:[quote author=C Nation link=topic=201842.msg2464893#msg2464893 date=1307896695]
school data base undhi bhayya.
every student ki tons of data untadhi. antha data okkatey table lo save cheyyamu kada.
Students ane table lo STudentID,studentname.. inko 2 -3 columns untayi.
Address ane table lo studentID, Add1,add2,city,state,zip etc.
Classes ane table lo studentID,ClassID, marks etc.
Parents ane table, STudentID,FatherName,MotherNAme etc.

so when ur searching/displaying data of particular student we use joins and get data of that particular student from all the tables.
[/quote] thankyou[quote author=GAJADONGA GANGULU link=topic=201842.msg2464888#msg2464888 date=1307896619]
simple baa.. [b]PRIMARY KEY[/b]: [b]UNIQUE + NOT NULL[/b]

JOINS:
Lets say there are two tables, TableA and TableB

[b]Inner join[/b] produces only the set of records that match in both Table A and Table B.
[code]SELECT * FROM TableA
INNER JOIN TableB
ON TableA.field= TableB.field[/code]
[img]http://codinghorror.typepad.com/.a/6a0120a85dcdae970b012877702708970c-pi[/img]

[b]Full outer join[/b] produces the set of all records in Table A and Table B, with matching records from both sides where available. If there is no match, the missing side will contain null.
[code]SELECT * FROM TableA
FULL OUTER JOIN TableB
ON TableA.field= TableB.field[/code]
[img width=502 height=329]http://codinghorror.typepad.com/.a/6a0120a85dcdae970b012877702725970c-pi[/img]

[b]Left outer join[/b] produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null.
[code]SELECT * FROM TableA
LEFT OUTER JOIN TableB
ON TableA.field= TableB.field[/code]
[img width=502 height=329]http://codinghorror.typepad.com/.a/6a0120a85dcdae970b01287770273e970c-pi[/img]

To produce the set of records only in Table A, but not in Table B, we perform the same left outer join, then exclude the records we don't want from the right side via a where clause.
[code]SELECT * FROM TableA
LEFT OUTER JOIN TableB
ON TableA.field= TableB.field
WHERE TableB.id IS null[/code]
[img width=502 height=329]http://codinghorror.typepad.com/.a/6a0120a85dcdae970b012877702754970c-pi[/img]

To produce the set of records unique to Table A and Table B, we perform the same full outer join, then exclude the records we don't want from both sides via a where clause.
[code]SELECT * FROM TableA
FULL OUTER JOIN TableB
ON TableA.name = TableB.name
WHERE TableA.id IS null
OR TableB.id IS null[/code]
[img width=502 height=329]http://codinghorror.typepad.com/.a/6a0120a85dcdae970b012877702769970c-pi[/img]

There's also a cartesian product or cross join
[code]SELECT * FROM TableA CROSS JOIN TableB[/code]
This joins "everything to everything", resulting in 4 x 4 = 16 rows, far more than we had in the original sets. If you do the math, you can see why this is a very dangerous join to run against large tables.

source: [url=http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html]http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html[/url]
[/quote]

[king420]

select girls from people_in_world where age > 21 and age < 25 and color = white and beauty = high;  &D_@@ &D_@@ &D_@@ &D_@@ &D_@@

[maaditenali]

[quote author=HAPPYNESS link=topic=201842.msg2465067#msg2465067 date=1307902018]
select girls from people_in_world where age > 21 and age < 25 and color = white and beauty = high;  &D_@@ &D_@@ &D_@@ &D_@@ &D_@@
[/quote]

no results found. please check query.  @3$% @3$% @3$% @3$% @3$% @3$% @3$% @3$%

[king420]

[quote author=GAJADONGA GANGULU link=topic=201842.msg2465080#msg2465080 date=1307902299]
no results found. please check query.  @3$% @3$% @3$% @3$% @3$% @3$% @3$% @3$%
[/quote]

ante mana db lo ammulu,bujji vellu bagora  cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl

[maaditenali]

[quote author=HAPPYNESS link=topic=201842.msg2465090#msg2465090 date=1307902441]
ante mana db lo ammulu,bujji vellu bagora  cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl
[/quote]
CITI_c$y CITI_c$y CITI_c$y no comment no comment no comment no comment nannu involve cheyyakandi happyness garu.....

[king420]

[quote author=GAJADONGA GANGULU link=topic=201842.msg2465105#msg2465105 date=1307902599]
CITI_c$y CITI_c$y CITI_c$y no comment no comment no comment no comment nannu involve cheyyakandi happyness garu.....
[/quote]

chestha chestha  cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl

[maaditenali]

[img]http://www.bewarsetalk.net/discus/movieanimated4/gutaka.gif[/img][quote author=HAPPYNESS link=topic=201842.msg2465119#msg2465119 date=1307902777]
chestha chestha  cry@fl cry@fl cry@fl cry@fl cry@fl cry@fl
[/quote]

[king420]

[quote author=GAJADONGA GANGULU link=topic=201842.msg2465131#msg2465131 date=1307902944]
[img]http://www.bewarsetalk.net/discus/movieanimated4/gutaka.gif[/img]
[/quote] chesa  :0012391: :0012391: :0012391: :0012391: :0012391: :0012391:

[els123]

*=: *=: *=: *=: *=: *=: