Scribd
Upload
20 views1 page

SQL Project Management Commands

The document contains SQL statements to create a project details table, select all records from the table, insert a new record into the table, update an existing record's status, count records by status, and compare end dates to the current date.

Uploaded by

sss
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
20 views1 page

SQL Project Management Commands

The document contains SQL statements to create a project details table, select all records from the table, insert a new record into the table, update an existing record's status, count records by status, and compare end dates to the current date.

Uploaded by

sss
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

create table details(project_name varchar(50) primary key,reason

varchar(50),typeofproject varchar(50),division varchar(50),category


varchar(50),priorityofproject varchar(50),department varchar(50),startdate
date,enddate date,projectlocation varchar(50),projectstatus varchar(50))

select * from deatils

insert into details values('Project 2','Dealership','External','Filters','Quality


B','Low','Finance','12/14/2021','12/02/2022','Mumbai','Cancel')

UPDATE QUERY
update project set projectstatus='cancel' where project_name='Project 1'

COUNT REGISTERED QUERY


select count(projectstatus) as registered from project

COMPARE END WITH CURRENT DATE


select count(*) as "closure delay" from project where enddate<=getdate()

You might also like