Re: SQL Query Question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38642
interpreted = N
texte = Try these:http://www.sqlcourse.comThis 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.comThis 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/-- ====================================================================== Britt Thompson | PO Box 1989 FishingWorld.com | Lindale, TX 75771 Easttexas.com | Ph: (903) 882-8877 / Fax: (903) 882-3110 ======================================================================------------------------------------------------------------- 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)
Try these:http://www.sqlcourse.comThis 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.comThis 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/-- ====================================================================== Britt Thompson | PO Box 1989 FishingWorld.com | Lindale, TX 75771 Easttexas.com | Ph: (903) 882-8877 / Fax: (903) 882-3110 ======================================================================------------------------------------------------------------- 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/ Britt T.

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:

(2000) Virtual hosting and webcatNT (1997) For those of you not on the WebCatalog Beta... (1997) [WebDNA] WebDNA and MAMP/Apache (Mac) (2018) FlushDatabase Suggestion (1998) authorizenet and netscape (2002) Grant, please help me ... (1997) Change to 5.0 per website licensing (2003) [Fwd: F3 database munching] (1997) OT: Limit on # of Pulldown entries (1997) Problems with 2.1b4 (1997) Users and groups for local directories (1999) WebMerchant when CC network is down - bug? (1998) WebCat b13 CGI -shownext- (1997) More on the email templates (1997) Extended [ConvertChars] (1997) Imagemagick and fonts (2004) [WebDNA] How about a timer feature? (2009) WebCatalog for guestbook ? (1997) Re[3]: Re[3]: Problem with new formvariables (2000)