Query advance SQL database employee

-------------------------------------------------- --------  01. Calculation                 -------- -------------------------------------------------- /* Select * From Employee Select * From EmployeeAttendance */ -- Maximum, Minimum, Total -- You can put an Alias Name for the Field -- Example: Field Sum(HourlyWage) will be Field Total_HourlyWage Select Max(HourlyWage) as Max_HourlyWage, Min(HourlyWage)...

Query Basic SQL database employee

-------------------------------------------------- --------  01. Add Record                  -------- -------------------------------------------------- -- Recommended -- Tell the Field Name INSERT INTO Department (DepartmentNo, DepartmentName) VALUES (1, 'Restaurant') INSERT INTO Department (DepartmentNo, DepartmentName) VALUES (2, 'Bar') INSERT INTO Department (DepartmentNo,...

SQL Create Table Database Employee

CREATE TABLE Department ( DepartmentNo int not null default 0, DepartmentName varchar(20) not null default '' ) CREATE TABLE ShiftDetail ( ShiftNo int not null default 0, ShiftName varchar(20) not null default '', StartTime varchar(8) not null default '08:00:00', EndTime varchar(8) not null default '16:00:00' ) CREATE TABLE Employee ( EmployeeId int not null default 0, FirstName varchar(20) not null default '', ...

oracle database work

Oracle database is a collection of physical operating system files or disks (in the simplest terms). Oracle instance is set of Oracle background processes or threads and a shared memory area, which is memory that is shared across those threads or processes running on a single computer. There are basically 9 Processes but in a general system we need to mention the first five background processes.They...

How dangerous is the coronavirus 2020

The coronavirus is extremely dangerous, and I suspect that the danger is currently being underplayed by the world medical community to minimize panic as we prepare for the worst. Covid-19 is deadly, although fatality rates skyrocket for the elderly and those with compromised immune systems. First and foremost, it is really important to know that as of today (February 17, 2020), there is still much we do not know about SARS-CoV-2 (i.e....

What is the difference between DBMS and SQL

DBMS is a system and SQL is a language DBMS (Database Management System)A DBMS is a software for creating and managing databases. The DBMS provides users with a systematic way to create, retrieve, update and manage data. It is a middleware between the database which store all the data and the users or applications which need to interact with that stored database. A DBMS can limit what data the end user sees, as well as how...

Spiderman : Homeless Recent Buzz about the Exit of Spiderman Franchise from MCU

In a Sony statement to USA TODAY Tuesday night, the studio said the outstanding issue remained over the future involvement of Marvel President, and comic movie mastermind, Kevin Feige as producer in future Spider-man films.     So when the two companies agreed to share his rights in 2015, it felt like a homecoming -- Spider-Man...

Pulo Cinta Resort is an Indonesian Maldives

Pulo Cinta has a very unique historical story. Once upon a time during the Dutch colonial era, this island became a place of escape between the Prince of Gorontalo and the daughter of one of the Dutch traders. When that war broke out and was expelled from the local community. As a result their love is not condoned. They finally chose...

Mini Africa Savanna in Wonderful Indonesia "Baluran National Park"

 Baluran National Park protects pasture animals such as buffalo, buffalo, deer, long-tailed monkey and long-tailed bird, peacock. You can see where they are grazing in the middle of the savanna. Every now and then, a herd of deer will cross your vehicle that is passing the road. This scene is often found in pastures...

Most Romantic married Dwayne Johnson and Lauren Hashian

  Dwayne Johnson was born in Hayward, California, United States, May 2, 1972. 47 years old is an American actor and professional wrestler at WWE known  as "The Rock". recently conducted a romantic marriage with an actress named Lauren Hashian. He announced the news in an Instagram post, featuring the couple with their arms...

Configure IP address on router using the Setup command

[admin@MikroTik] > setup   Setup uses Safe Mode. It means that all changes that are made during setup are reverted in case of error, or if [Ctrl]+[C] is used to abort setup. To keep changes exit setup using the [X] key. [Safe Mode taken]   Choose options by pressing one of the letters in the left column, before dash. Pressing [X] will exit current menu, pressing Enter key will select the entry that is marked by...

basic configuration the Mikrotik

Before configuring the IP addresses and routes please check the /interface menu to see the list of available interfaces. If you have Plug-and-Play cards installed in the router, it is most likely that the device drivers have been loaded for them automatically, and the relevant interfaces appear on the /interface print [admin@MikroTik] interface> print Flags: X - disabled, D - dynamic, R - running # NAME...

Basics proxy setup for beginners

Normally you connect to the router by IP addresses with any telnet or SSH client software (a simple text-mode telnet client is usually called telnet and is distributed together with almost any OS). You can also use graphical configuration tool for Windows (also can be run in Linux using Wine) called Winbox. To get Winbox, connect to the router's IP address with a web browser, and follow the link to download winbox.exe...