| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> http://putative.typepad.com/putative/2007/01/fedex_refuses_s.html
<0> The FedEx guy then grabs cans of nitrogen (N2) and neon (Ne), with their store-advertised "purity" of 78.084% and 0.0018% respectively (which was our way of being clever about selling cans of normal air, since that's their percentage in the atmosphere
<0> heh
<0> booooring
<1> i have 2 relation table ( Person and History )
<1> the record of my table person is : Id=1 - Name=John
<2> the recor in History table is :
<2> Id=1 IdPerson=1 History= December-12-2007
<2> Id=2 IdPerson=1 History= December-14-2007
<2> what sql syntak query to select person and Recent Query so result is "John - December-14-2007" ?
<2> select Person.name,History.History from Person innerjoin History in Person.id = History.IdPerson ??
<2> but i want top or maximal in history.
<2> this is like nested select.
<3> iii but i want top or maximal in history.
<3> ij ZZZZZZ this is like nested select.
<3> - j B
<3> j j i B
<3> zwwB m { ii B
<3> x Bx iiiiiiin
<3> x A A iiiiiiio
<3> x A ZZZ iiiiiiio
<3> x Y \\\\ \\\\ iiiim
<3> x Y efhiiigiiiiiii
<3> lol
<2> ?
<3> is that u ?
<2> u get it my mean ??
<2> i am serious
<2> in second table of my relation, i dont want show all with inner join, but just top.
<2> 1 top.
<2> how sql query ???
<2> select * from person inner join history in person.id = history.idperson will be result :
<2> john december-1-2001
<2> john december-1-2003
<2> but i just want
<2> john december-1-2003
<2> coz december-1-2003 is a top / maximal date.
<2> how sql syntax of that ??
<3> show top1 ?
<3> you can use order by
<3> or select top1
<3> select distinct
<3> choose any of that which suits u
<2> how ??
<2> top is not of all result query but just in table history.
<2> u get it my mean ??
<2> so i cant use select top
<2> select top 1 from person inner join history in person.id = history.idperson ------->>> this is wrong logic
<2> select * from person inner join history in person.id = history.idperson where history is TOP.
<2> i want like that.
<2> i think u are not get it.
<2> my table Person is ( Id,Name)
<2> my table History is ( Id,IdPerson,Date)
<2> value of table person is : 1,John - 2,Marry
<3> select top1 from (select blah balh inner join blah blah)
<3> get that ?
<3> use your condition inthe ()
<2> value of table History is ( 1,1,12-December-2001 * 2,1,13-december-2001 * 3,2,14-december-2001 * 4,2,15-december-201 )
<2> what sql query so result is
<2> john,13-december-2001 * Marry,14-December-2001
<2> how ????????
<2> john 12-december-2001 not appear coz 12-december-2001 is maximal date.
<2> Marry 13-december-2001 not appear coz marry,14-december-2001 is maximal date.
<2> how ????
<2> i need complete sql query of my question.
<2> select person.name from person inner join top 1 inthe ( history.date) bla bla ?????????????????
<3> ...
<2> u get it my mean now ??
<3> you need "IN"
<3> not in the
<3> inthe
<2> i need complete query please..
<2> doh.....
<3> dude
<3> seriously
<3> i didnt really read what u said
<3> and now i just did
<3> and i think i need to get some sleep
<3> your english is killing me
<2> no problem. thanks alot......
<2> i have get the answer
<2> SELECT *
<2> FROM child_table, parent_table
<2> WHERE foreign_key=primary_key AND primary_key=(SELECT top 1 primary_key FROM parent_table)
<2> no flood......
<4> @clocKwize?
<0> *shrug*
<0> I didn't do it
<5> hmm
<4> the hostname looks familiar though =p
<4> !seen clocKwize
<6> Smirker, Hey moron, look at the nick list would you?
<4> previous names though, DinnerLizard?
<7> !seen MudBlud
<6> Re_Boot, I found 3 matches to your query: clocKwize, clocKwize_1, MudBlud. clocKwize (clocKwize@82-34-109-136.cable.ubr07.gill.blueyonder.co.uk) was last seen joining #vb.net 1 day 2 hours 22 minutes ago (12.01. 18:52). clocKwize is still there.
<7> nice ubr07
<4> i feel hurt by DinnerLizard : <
<7> yes, rather matter of fact, isnt he?
<5> cockwize is muddy?
<7> ah, really?
<4> thats what it says
<7> does not
<7> really
<7> ?
<7> where?
<4> Re_Boot, I found 3 matches to your query: clocKwize, clocKwize_1, MudBlud. clocKwize (clocKwize@82-34-109-136.cable.ubr07.gill.blueyonder.co.uk)
<7> is that so?
<4> that is a list of all the names registered to the stored hostmask
<7> </sarcasim>
<7> :P
<4> oh ;o
<7> I learn you yet....
<5> lol
<8> hi
<8> Basically, I only want to select the first row from the first table but this table has many records ***ociated with it in the second table and I only get the first row returned for the second table as well.
<8> I want to be able to get all of the ***ociated rows from the second table that match the top row I select from the first. How would I achieve this?
<8> Thanks for your help :)
<9> use TOP and a join?
<8> yes
<9> sounds like you already knew the answer, then
<8> thats wrong
<8> the result is wrong.
<8> SELECT distinct person.nama,( select top 1 jabatan.tmtjabatan from jabatan order by jabatan.tmtjabatan desc)
<8> FROM jabatan inner join person on person.id = jabatan.idperson
<9> that looks horribly incorrect
<8> wrong in top 1
<8> that code always show top 1
<8> my sturucture of first table "Person" = Id,Name
<9> sounds like you should do two queries
<9> one to get the top row of jabatan
<9> and one to get all the matching rows from person
<8> yup!! thats right
<9> go do that then, isntead of doing it in one query
<8> but the result wrong in jabatan,he always show top 1 of jabatan. i want show top 1 of jabatan but suitable with person.
<8> ======================================================
<8> my sturucture of first table "Person" = Id,Name
<9> so you said
<9> do it in two queries
<8> how ?
<9> well, it's like doing one query
<9> except it's two
<9> open up a recordset for the first query, which gets you the top row
<9> and then use the values from that to create your second recordset
<8> thats bad....
<9> if you say so
<8> i have to use "If logic" to query it.
<8> my sturucture of first table "Person" = Id,Name
<9> for ****'s sake
<9> if you say that line one more time
Return to
#vb
or
Go to some related
logs:
#allnitecafe
orlandopoolsbydesign
#allnitecafe
ircerr
#kl
vanila ice baby
#chat-world
california materistic
#worldchat
php array shell sort
|
|