|
1> CREATE TABLE project (project_no CHAR(4) NOT NULL,
2> project_name CHAR(15) NOT NULL,
3> budget FLOAT NULL)
4>
5> insert into project values ('p1', 'Search Engine', 120000.00)
8> GO
(1 rows affected)
1> -- An expression can also be a part of the condition in the WHERE clause
2>
3> SELECT project_name FROM project WHERE budget*0.51 > 60000
4> GO
project_name
---------------
Search Engine
SQL
(2 rows affected)
1>
2> drop table project
3> GO
1>
|