Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
make "meny to meny" as "one to meny"
hello, i know the what i want to do, is the opposite of 3ed noraml Form DB. but this is my case! i have table costemers. includes "name" column i have talbe orders. includes "date" and "amount" column i would like to read costerms who thier name starts with 'm' and i want to read in the same... -
Use max but no Group by :)
but this will work :) SELECT TOP 1 ID FROM Table WHERE (id = 123) ORDER BY count DESC thx again :) SQL is POWERFUL -
Use max but no Group by :)
hi nicsin, no Top 1 wont work. i will give the row with count=1. i need the count= 2 in the example up :) thx -
Use max but no Group by :)
thank you guys. the example helped :) i wonder that there is no sth like the Opposite of TOP 1 if i say select TOP 1 count, text from Table where id=123 i will get the ROW where count=1. sql will be more powerful if it includes sth like TOP max to give the LAST ROW. thx. -
Use max but no Group by :)
if i group by the date for example i will get all rows where id=123, and i dont want that. i searched the forum and i found sth like TOP 10 thread220-733075 i need ONLY the last ROW in my example the raw with count=2 btw, this count is varialbe so users have 100 count other have 200 count, i... -
Use max but no Group by :)
hi, i have such table count id text date 1 123 blablaa 01.01.2004 2 123 booboo 12.12.2003 1 321 dddddd 14.01.2003 now i want to show only the max(count) ROW but without th group by the rest where...
