Re: SQL Query Question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38644
interpreted = N
texte = select distinct item1 from table1 where item in (select distinct item2 from table1) order by item1, item2 on 18/9/01 9:35 AM, Britt T. at Britt@fishingworld.com wrote:> Try these: > > http://www.sqlcourse.com > > This unique introductory SQL tutorial not only provides > easy-to-understand SQL instructions, but it allows you to practice > what you learn using the on-line SQL interpreter. You will receive > immediate results after submitting your SQL commands. You will be > able to create your own unique tables as well as perform selects, > inserts, updates, deletes, and drops on your tables. This SQL > tutorial currently supports a subset of ANSI SQL. The basics of each > SQL command will be covered in this introductory tutorial. Unless > otherwise stated, the interpreter will support everything covered in > this course > > > http://www.sqlcourse2.com > > This unique SQL Tutorial is the sequel to the highly successful > SQLCourse.com site and will provide you with more advanced > easy-to-follow SQL Instruction and the ability to practice what you > learn on-line with immediate feedback! You will receive immediate > results on a web page after submitting your SQL Commands. This > continuation course will provide you with critical need-to-know > advanced features and clauses of the SELECT statement that weren't > supported in the previous SQLCourse.com site. Everything you learn > here will be ANSI SQL compliant and should work with most SQL > databases such as Oracle, SQL Server, mySQL, MS Access, Informix, > Sybase, or any other ANSI SQL compliant database. > > If you're already familar with the basics of SQL, you can still use > this as a refresher, and practice some SQL statements. > > > > > >> SELECT DISTINCT ItemType FROM >> >> John. >> >>> I need to perform a query on an SQL datasource and summarize the results of >>> a couple of the columns in the table. To do this in WebCat is no problem, >>> but I can't figure out the equivalent syntax in SQL. Any help would be >>> appreciated. >>> >>> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T] >>> >>>

>>> >>> [/search] >>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >> >> >> --------------------------------- >> John A. Hill >> Oak Hill Software >> Website Development/Consulting >> john@oakhillsoftware.com >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL Query Question (Andrew Simpson 2001)
  2. Re: SQL Query Question (Britt T. 2001)
  3. Re: [OT] was Re: SQL Query Question (Charles Kline 2001)
  4. Re: [OT] was Re: SQL Query Question (John Peacock 2001)
  5. Re: SQL Query Question (Charles Kline 2001)
  6. [OT] was Re: SQL Query Question (John Peacock 2001)
  7. Re: SQL Query Question (John Hill 2001)
  8. SQL Query Question (Charles Kline 2001)
select distinct item1 from table1 where item in (select distinct item2 from table1) order by item1, item2 on 18/9/01 9:35 AM, Britt T. at Britt@fishingworld.com wrote:> Try these: > > http://www.sqlcourse.com > > This unique introductory SQL tutorial not only provides > easy-to-understand SQL instructions, but it allows you to practice > what you learn using the on-line SQL interpreter. You will receive > immediate results after submitting your SQL commands. You will be > able to create your own unique tables as well as perform selects, > inserts, updates, deletes, and drops on your tables. This SQL > tutorial currently supports a subset of ANSI SQL. The basics of each > SQL command will be covered in this introductory tutorial. Unless > otherwise stated, the interpreter will support everything covered in > this course > > > http://www.sqlcourse2.com > > This unique SQL Tutorial is the sequel to the highly successful > SQLCourse.com site and will provide you with more advanced > easy-to-follow SQL Instruction and the ability to practice what you > learn on-line with immediate feedback! You will receive immediate > results on a web page after submitting your SQL Commands. This > continuation course will provide you with critical need-to-know > advanced features and clauses of the SELECT statement that weren't > supported in the previous SQLCourse.com site. Everything you learn > here will be ANSI SQL compliant and should work with most SQL > databases such as Oracle, SQL Server, mySQL, MS Access, Informix, > Sybase, or any other ANSI SQL compliant database. > > If you're already familar with the basics of SQL, you can still use > this as a refresher, and practice some SQL statements. > > > > > >> SELECT DISTINCT ItemType FROM >> >> John. >> >>> I need to perform a query on an SQL datasource and summarize the results of >>> a couple of the columns in the table. To do this in WebCat is no problem, >>> but I can't figure out the equivalent syntax in SQL. Any help would be >>> appreciated. >>> >>> [search db=some.db&neItemIDdata=BLANK&ItemTypesumm=T&ItemCatsumm=T] >>> >>>

>>> >>> [/search] >>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >> >> >> --------------------------------- >> John A. Hill >> Oak Hill Software >> Website Development/Consulting >> john@oakhillsoftware.com >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Is this possible, WebCat2.0 and checkboxes (1997) how is this possible (2000) WCS Newbie question (1997) Storebuilder Problems...Looking for last minute heroic (2004) WebCat2 - [format thousands] (1997) Answer: WebDelivery downloads alias, not original ? (1997) ConverChars (1999) Exclamation point (1997) OT: MacAuthorize (2001) WebCat chatroom (1997) Expiration of Carts (1997) Roundup function? (1997) convertWords... (2001) multiple selected Checkboxes (1998) Banners (1997) Sorry - the list went haywire... (1998) Email Problem (1997) [searchString] (1997) AppleScript question (1997) AuthenticateChecker (2000)