At 09:10 AM 6/4/2002 -0400, Mike Sinclair wrote:
>Can somebody give me an example of the syntax to create a single table >view using group by and having? If I have a table with 3 coulums, rdate >service and price, and I want the view to show just 1 row for each service >and some permutation of the price (such as min, max, last, first, count, >etc), what magic sentence would make that view? Mike, Inside R:BASE (2nd Edition) by Anne Gillihan includes excellent technical topics! Call RBTI sales team at 724.733.0053 or e-mail: mailto:[EMAIL PROTECTED] Good Luck! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
