| No Title | |
|---|---|
| Identifier | 1270 |
| Weight | 1.0 |
| Publication Date | 2006-04-06 13:23:00.00 |
| title |
| identification d'un rapport |
| body |
| Bonjour, j'aurais voulu savoir à quel rapport correspondait cette requête sql: SELECT REQUEST.REQUESTTYPE, REQUEST.FORMNAME, REQUEST.REQUESTEMAILBOX, COUNT (*), SUM (REQUEST.INCOMINGEMAILSNBR) FROM REQUEST, REQUESTSTATEVENT WHERE REQUEST.REQUESTID = REQUESTSTATEVENT.REQUESTID AND REQUESTSTATEVENT.REQUESTNEWSTATUS <> 1 AND REQUESTSTATEVENT.STATEVENTID IN (SELECT MAX (REQUESTSTATEVENT.STATEVENTID) FROM REQUESTSTATEVENT, STATEVENT WHERE REQUESTSTATEVENT.STATEVENTID = STATEVENT.STATEVENTID AND STATEVENT.EVENTDATE <= :1 GROUP BY REQUESTSTATEVENT.REQUESTID) GROUP BY REQUEST.REQUESTTYPE, REQUEST.FORMNAME, REQUEST.REQUESTEMAILBOX Merci. Emmanuel. |
| 30 most frequent features | Frequency | Zone |
|---|---|---|
| /PROPER-NAME/AND | 3 | |
| /COMMON-NOUN/group | 2 | |
| /COMMON-NOUN/rapport | 2 | |
| /PROPER-NAME/Select | 1 | |
| /PROPER-NAME/COUNT | 1 | |
| /COMMON-NOUN/requête | 1 | |
| /COMMON-NOUN/sql | 1 | |
| /ADJ/in | 1 | |
| /NP/requête sql | 1 | |
| /PROPER-NAME/REQUESTSTATEVENT WHERE | 1 | |
| /COMMON-NOUN/bonjour | 1 | |
| /PROPER-NAME/REQUESTSTATEVENT | 1 | |
| /COMMON-NOUN/identification | 1 | |
| /PROPER-NAME/STATEVENT WHERE | 1 | |
| /PROPER-NAME/Select Max|max | 1 | |
| /VERB/savoir | 1 | |
| /NP/identification de un rapport | 1 | |
| /VERB/correspondre | 1 | |
| /PROPER-NAME/REQUEST | 1 | |
| /COMMON-NOUN/merci | 1 | |
| /PROPER-NAME/SUM | 1 | |
| /PROPER-NAME/Emmanuel | 1 |