Adding data SQL task | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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.

22nd Dec 2023, 1:28 PM
Dariusz Jenek
Dariusz Jenek - avatar
4 Answers
+ 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.
23rd Dec 2023, 11:32 AM
Lothar
Lothar - avatar
+ 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;
22nd Dec 2023, 5:00 PM
卂ㄚㄩ丂卄
卂ㄚㄩ丂卄 - avatar
+ 1
Lothar Alright will have this in mind for next time 👍
23rd Dec 2023, 1:00 PM
卂ㄚㄩ丂卄
卂ㄚㄩ丂卄 - avatar
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
24th Dec 2023, 9:09 AM
فواز المصلح
فواز المصلح - avatar