принтерах, которые являются матричными и стоят меньше $300 SELECT * FROM Printer WHERE type = 'matrix' AND price < 300; Следующий запрос не вернёт ни одной записи, поскольку сравнение происходит искомому столбцу. Поиск проектов в именах, которых присутствует подстрока «Map»: SELECT * FROM PROJECT WHERE PROJ_NAME CONTAINING 'map'; В данном случае будет возвращены две строки с именами «AutoMap» проекты. SELECT * FROM employee WHERE EXISTS (SELECT * FROM employee_project ep WHERE ep.emp_no = employee.emp_no) Пример 3.6. Предикат NOT EXISTS

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 This syntax is compatible with OrgMode @startwbs * Business Process Modelling WBS ** Launch the project *** Complete Stakeholder Research *** Initial Implementation Plan ** Design phase *** Model of AsIs

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 This syntax is compatible with OrgMode @startwbs * Business Process Modelling WBS ** Launch the project *** Complete Stakeholder Research *** Initial Implementation Plan ** Design phase *** Model of AsIs

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 This syntax is compatible with OrgMode @startwbs * Business Process Modelling WBS ** Launch the project *** Complete Stakeholder Research *** Initial Implementation Plan ** Design phase *** Model of AsIs

using the start verb: @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 @enduml conjunction) 10 GANTT DIAGRAM @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] ends 2020-07-15 [Test prototype] ends 2020-07-25 @enduml 10 10.1.4 Start/End It is possible to define both absolutely, by specifying dates: @startuml Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 [Prototype

using the start verb: @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 @enduml conjunction) 10 GANTT DIAGRAM @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] ends 2020-07-15 [Test prototype] ends 2020-07-25 @enduml 10 10.1.4 Start/End It is possible to define both absolutely, by specifying dates: @startuml Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 [Prototype

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 Technology_Service(internetBrowser, "Internet Browser Generic & Plugin") Technology_Service(internetBrowserPlugin, "Some Internet Browser Plugin") Technology_Service(webServer, "Some web server") 'Relationships

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 Technology_Service(internetBrowser, "Internet Browser Generic & Plugin") Technology_Service(internetBrowserPlugin, "Some Internet Browser Plugin") Technology_Service(webServer, "Some web server") 'Relationships

10.6 Calendar You can specify a starting date for the whole project. By default, the first task starts at this date. @startgantt Project starts the 20th of september 2017 [Prototype design] as [TASK1] in Lavender/LightBlue @endgantt 10.7 Close day It is possible to close some day. @startgantt project starts the 2018/04/09 saturday are closed sunday are closed 2018/05/01 is closed 2018/04/17 to 2018/04/19 Technology_Service(internetBrowser , "Internet Browser Generic & Plugin") Technology_Service(internetBrowserPlugin , "Some Internet Browser Plugin") Technology_Service(webServer, "Some web server") 'Relationships

using the start verb: @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 @enduml using the end verb: @startuml [Prototype design] lasts 15 days [Test prototype] lasts 10 days Project starts 2020-07-01 [Prototype design] ends 2020-07-15 Справочное руководство по языку PlantUML (1 @enduml 16.1.4 Start/End It is possible to define both absolutely, by specifying dates: @startuml Project starts 2020-07-01 [Prototype design] starts 2020-07-01 [Test prototype] starts 2020-07-16 [Prototype