need HELP with SQL practice tutorials

[CORLEONE]

[quote author=KINDAL link=topic=193762.msg2361782#msg2361782 date=1305613321]
thankyou thankyou
will try ba  CITI_$D# H&*()
[/quote]nuvvu deni paina chestunnav mama ?? nenu kuda ippudippude sql nerchukuntunnaa,,,,,,,,,

[chowdary10]

[quote author=CORLEONE link=topic=193762.msg2361790#msg2361790 date=1305613778]
nuvvu deni paina chestunnav mama ?? nenu kuda ippudippude sql nerchukuntunnaa,,,,,,,,,
[/quote]

nenu nirudhyogi ni baa  F@!n

[banti321]

[quote author=KINDAL link=topic=193762.msg2361788#msg2361788 date=1305613629]
chusa  @3$%
[/quote]anni sinnappude susette ippudu em migultayi sudadaniki CITI_c$y CITI_c$y

[CORLEONE]

[quote author=KINDAL link=topic=193762.msg2361791#msg2361791 date=1305613962]
nenu nirudhyogi ni baa  F@!n
[/quote]ade mama e tech. paina train avutunnaav ani,,,,,,,,,,,  &D_@@ &D_@@

[chowdary10]

[quote author=Well Educated link=topic=193762.msg2361792#msg2361792 date=1305614020]
anni sinnappude susette ippudu em migultayi sudadaniki CITI_c$y CITI_c$y
[/quote]

ippude susa ba nuvvu sudamannavu ani.. taravata emi seyyali  F%G_@

[chowdary10]

[quote author=CORLEONE link=topic=193762.msg2361794#msg2361794 date=1305614158]
ade mama e tech. paina train avutunnaav ani,,,,,,,,,,,  &D_@@ &D_@@
[/quote]

sql ba nuvvu

[CORLEONE]

[quote author=KINDAL link=topic=193762.msg2361798#msg2361798 date=1305614379]
sql ba nuvvu
[/quote]ooh avunaa,,,,,,,,,,  CITI_$D# naadi people-soft mama  s%H# s%H#

[chowdary10]

[quote author=CORLEONE link=topic=193762.msg2361799#msg2361799 date=1305614434]
ooh avunaa,,,,,,,,,,  CITI_$D# naadi people-soft mama  s%H# s%H#
[/quote]

atb ba  H&*()

[CORLEONE]

[quote author=KINDAL link=topic=193762.msg2361802#msg2361802 date=1305614492]
atb ba  H&*()
[/quote]thnx and neeku kuda,,,,,,,,,,  F@#da F@#da

[boring]

[quote author=TollywoodEmperor link=topic=193762.msg2361656#msg2361656 date=1305608282]
Baa naku aa websites teliyavu kani, nannu interviewlo adigina one Q aduguthanu ...

.1. what is the rsult of the following

select * from Employees where EmployeeID IN (select * from Employee_Incomes)
idhi subquery...Dheeni results lo ye columns vasthayi



sSa_j@il sSa_j@il sSa_j@il sSa_j@il sSa_j@il
[/quote]

isnt it an error?

[boring]

sql is simple and similar to english.

ask what you want to see(columns)
from where(tables)
under what conditions(where clause etc)
arrange them in low to high(order by)

its like reading a novel. just need to know what we want and then write a query using sql lang instead of english.

[Jambhalheart]

ok mama...

as a task... do this simple one...


There is a table A with 20 records... Now , write a query for displaying records from 5 to 10.. I mean from 5th record to 10th record(including)...




( neeku Stored procedures vasthe cheppu mama, manchi practise tasks chepthanu.. )

[chowdary10]

[quote author=boring link=topic=193762.msg2361823#msg2361823 date=1305615343]
sql is simple and similar to english.

ask what you want to see(columns)
from where(tables)
under what conditions(where clause etc)
arrange them in low to high(order by)

its like reading a novel. just need to know what we want and then write a query using sql lang instead of english.
[/quote]
*=: made it easier  thankyou

[boring]

[quote author=Jambhalheart link=topic=193762.msg2361824#msg2361824 date=1305615396]

ok mama...

as a task... do this simple one...


There is a table A with 20 records... Now , write a query for displaying records from 5 to 10.. I mean from 5th record to 10th record(including)...




( neeku Stored procedures vasthe cheppu mama, manchi practise tasks chepthanu.. )
[/quote]

oracle lo aithe simple. use rowid

[Jambhalheart]

[quote author=boring link=topic=193762.msg2361827#msg2361827 date=1305615539]
oracle lo aithe simple. use rowid
[/quote]
I know lol...


but one shuld try doing it in sql server...