| ALL Keyword [message #1442] |
Wed, 01 May 2002 03:12  |
casper
Messages: 3
Registered: May 2002
|
Junior Member |
|
|
Is ALL keyword exist SQL+?
For example, How can I make work this query :
SELECT count(*) FROM action GROUP BY ALL field ORDER BY field;
|
|
|
|
| Re: ALL Keyword [message #1453 is a reply to message #1442] |
Wed, 01 May 2002 20:53  |
Amit
Messages: 166
Registered: February 1999
|
Senior Member |
|
|
Yes 'All' keyword exist in SQL+
you can not use all keyword in group by function like you used in example
All keyword used like this:
" select column1,column2 from table where column1(say salary)>all(select column1(salary) from table "
also you can add where condition if you want
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
