0
Adding data SQL task
Could You help me with a soloution of this task, please? I really do not know how to solve it. Adding Data There are new employees that need to be added to the Employees table. Here is their data: Firstname: Wang Lastname: Lee Salary: 1900 Firstname: Greta Lastname: Wu Salary: 1200 The Employees table has an identity column called id, which is set to AUTO_INCREMENT. Add the data to the table, then select the id, firstname, lastname and salary columns sorted by the id column in descending order.
4 ответов
+ 6
卂ㄚㄩ丂卄 ,
it is not seen as very helpful when we are going to post a ready-made code, as long as the op has not shown his attempt here.
it is more helpful to give hints and tips, so that the op has a chance to find a solution by himself.
+ 2
INSERT INTO Employees (firstname, lastname, salary) VALUES
('Wang', 'Lee', 1900),
('Greta', 'Wu', 1200);
SELECT id, firstname, lastname, salary
FROM Employees ORDER BY id DESC;
+ 1
Lothar Alright will have this in mind for next time 👍
0
Just a little bit of a great rgv and the other one I was talking to at the end was a bit 9 for Android and