Notes
Notes - notes.io |
select * from station
SELECT
E.Emp_Name,
E.EmailId,
S.StationID,
S.Station_Name
FROM Employee E
JOIN Station S ON E.StationId = S.StationID
WHERE E.EmailId = '[email protected]';
SELECT Emp_Name, StationId
FROM Employee
WHERE EmailId = '[email protected]';
UPDATE Employee
SET StationId = 11, Status = 'Active'
WHERE EmailId = '[email protected]';
Station assigned
-- Checking C. Vega for PWM assignment
SELECT Emp_Name, Emp_id, StationId, Status, EmailId
FROM Employee
WHERE EmailId = '[email protected]';
-- Checking Bram Ackay for current JFK/EWR assignments
SELECT Emp_Name, Emp_id, StationId, Status, EmailId
FROM Employee
WHERE EmailId = '[email protected]';
SELECT
E.Emp_Name,
E.EmailId,
S.StationID,
S.Station_Name
FROM Employee E
JOIN Station S ON E.StationId = S.StationID
WHERE E.EmailId = '[email protected]';
select * from Employee where EmailId = '[email protected]';
select * from Employee_Station where user_id = '[email protected]';
-------------------------------------------------------
SELECT Emp_Name, Emp_id, StationId, Status, EmailId
FROM Employee
WHERE EmailId = '[email protected]';
SELECT user_id, COUNT(DISTINCT station_id) AS total_stations_assigned
FROM Employee_Station
WHERE user_id IN ('[email protected]')
GROUP BY user_id;
SELECT
E.Emp_Name,
E.EmailId,
S.StationID,
S.Station_Name
FROM Employee E
JOIN Station S ON E.StationId = S.StationID
WHERE E.EmailId = '[email protected]';
select * from Employee where EmailId = '[email protected]';
select * from Employee_Station where user_id = '[email protected]';
UPDATE Employee
SET StationId = 5, Status = 'Active'
WHERE EmailId = '[email protected]';
UPDATE Employee
SET StationId = 17, Status = 'Active'
WHERE EmailId = '[email protected]';
INSERT INTO Employee_Station (user_id, station_id)
SELECT '[email protected]', s.StationID
FROM Station s
WHERE s.StationID IN (5)
AND s.StationID NOT IN (
SELECT station_id
FROM Employee_Station
WHERE user_id = '[email protected]'
);
|
|
Notes is a web-based application for online taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000+ notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 14 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
