TG: sql_for_qa/59

SQL для тестировщика

Какой из следующих SQL запросов выведет имена сотрудников и их менеджеров из таблиц "employee" и "manager"? Рядом с именем каждого сотрудника должно быть выведено имя его менеджера.

Anonymous Quiz

SELECT employee.name, manager.name FROM employee, manager WHERE employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee JOIN manager ON employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee INNER JOIN manager ON employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee LEFT JOIN manager ON employee.manager=manager.id;

631 answered

www.tg-me.com/us/SQL для тестировщика/com.sql_for_qa/59

2.6K viewsMar 14, 2023 at 06:20

tg-me.com/sql_for_qa/59

Create: 2023-03-14
Last Update: 2025-07-01 18:57:21

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/59

SQL для тестировщика Telegram | DID YOU KNOW?

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.

Telegram is riding high, adding tens of million of users this year. Now the bill is coming due.Telegram is one of the few significant social-media challengers to Facebook Inc., FB -1.90% on a trajectory toward one billion users active each month by the end of 2022, up from roughly 550 million today.