Jump to content

need HELP with SQL practice tutorials


Recommended Posts

Posted

[quote author=CORLEONE link=topic=193762.msg2365620#msg2365620 date=1305697327]
select distinct column1, column2,,,,,,,,,, from table xyz !  s%H# s%H#
[/quote]

select kaadhu baabu delete annaaa. read the Q before answering in interview.

  • Replies 117
  • Created
  • Last Reply

Top Posters In This Topic

  • chowdary10

    42

  • boring

    12

  • Jambhalheart

    11

  • chipanjichiru

    9

Top Posters In This Topic

Posted

[quote author=boring link=topic=193762.msg2365630#msg2365630 date=1305697623]
select kaadhu baabu delete annaaa. read the Q before answering in interview.
[/quote] !q# !q# !q#

Posted

[quote author=boring link=topic=193762.msg2365630#msg2365630 date=1305697623]
select kaadhu baabu delete annaaa. read the Q before answering in interview.
[/quote] Dr@w@ Dr@w@ Dr@w@

Posted

[quote author=boring link=topic=193762.msg2365630#msg2365630 date=1305697623]
select kaadhu baabu delete annaaa. read the Q before answering in interview.
[/quote]
@gr33d @gr33d understaning tha question is vey imp in sql

Posted

@to newbies....


write a query to display record of employee who has 3rd highest salary from employees table.....



for ex:

id salary
1  10000
2  4000
3  6000
4  500


Now u have to bring record 2 anamata.... got it ??

Posted

[quote author=Jambhalheart link=topic=193762.msg2365858#msg2365858 date=1305714864]
@to newbies....


write a query to display record of employee who has 3rd highest salary from employees table.....



for ex:

id salary
1  10000
2  4000
3  6000
4  500


Now u have to bring record 2 anamata.... got it ??
[/quote]

select * from table

where salery = '4000'
sSa_j@il sSa_j@il sSa_j@il correst e  na baa

Posted

[quote author=Very Well Educated link=topic=193762.msg2365864#msg2365864 date=1305715020]
select * from table

where salery = '4000'
sSa_j@il sSa_j@il sSa_j@il correst e  na baa
[/quote]

[img]http://i52.tinypic.com/rhq4n9.gif[/img]

CITI_c$y


table chusav kabatti, salary=4000 ani chepthuunav kada mama... wat if u want to extract the info from front end without looking at the values of salary column ??? u just know that there is salary column in table ....

how will u do that then ???

Posted

[quote author=Jambhalheart link=topic=193762.msg2365899#msg2365899 date=1305716029]
[img]http://i52.tinypic.com/rhq4n9.gif[/img]

CITI_c$y


table chusav kabatti, salary=4000 ani chepthuunav kada mama... wat if u want to extract the info from front end without looking at the values of salary column ??? u just know that there is salary column in table ....

how will u do that then ???
[/quote]
sorry2 ba koncham cheppu nerchukunta  CITI_$D#

Posted

[quote author=Very Well Educated link=topic=193762.msg2365903#msg2365903 date=1305716181]
sorry2 ba koncham cheppu nerchukunta  CITI_$D#
[/quote]

check ur pm mama... migilina vallani try cheyani...

Posted

thankyou CITI_$D# CITI_$D#[quote author=Jambhalheart link=topic=193762.msg2365912#msg2365912 date=1305716574]
check ur pm mama... migilina vallani try cheyani...
[/quote]

Posted

Nenu class theesukunnappudu students ki ikkada post cheyinchanu, almost anni unnai ikkada

[url=http://b4dl.com/naperville/forums/show/23.page]http://b4dl.com/naperville/forums/show/23.page[/url]

Posted

*=: *=: you rock you rock thankyou[quote author=bujjulu link=topic=193762.msg2365982#msg2365982 date=1305720569]
Nenu class theesukunnappudu students ki ikkada post cheyinchanu, almost anni unnai ikkada

[url=http://b4dl.com/naperville/forums/show/23.page]http://b4dl.com/naperville/forums/show/23.page[/url]
[/quote]

Posted

[quote author=KINDAL link=topic=193762.msg2361642#msg2361642 date=1305607925]
chadivaanu sql edo ala alaa

practice cheyataniki i need some tasks...

nenu oka danilo practicing kaani adi result ki  hint istundi kaani exact ga command ivvateldu  if i am rong

so sql practice ki edi ina site vunte ivvandi
thankyou thankyou thankyou
[/quote]




Prepare this mama...[url=http://www.sqlzoo.net]www.sqlzoo.net[/url]
It gives best practice for you.

×
×
  • Create New...