Skip to content

Instantly share code, notes, and snippets.

@sambhav2612
Created January 24, 2018 08:00
Show Gist options
  • Save sambhav2612/7a9f5cbb24db302019802d41e17d0ea0 to your computer and use it in GitHub Desktop.
Save sambhav2612/7a9f5cbb24db302019802d41e17d0ea0 to your computer and use it in GitHub Desktop.
Create Table dept33(
Dno Integer not null,
Dname varchar(50),
location varchar(50) Default 'New Delhi',
primary key(Dno)
);
DNO DNAME LOCATION
10 Accounting New York
30 Sales Chicago
20 Research Dallas
50 Marketing New Delhi
40 Operation Boston
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment