'Select c' presentation slideshows

568 views • 43 slides

C# 3.0 & LINQ

C# 3.0 & LINQ. ??? Visual C# MVP zmeun.tistory.com. Agenda. Part ?: C# 3.0 New Features. Part ? : Functional Programming. Part ? : LINQ (Language Integrated Query). C# 3.0 New Features. Var Local Variable. Anonymous Type. Auto-Implemented Properties.

565 views • 28 slides

Exercises

Exercises. Suppliers( sid: integer, sname: string, address: string) Parts( pid: integer, pname: string, color: string) Catalog( sid: integer, pid: integer, cost: real). Find the names of suppliers who supply some red part. SELECT S.sname FROM Suppliers S, Parts P, Catalog C

355 views • 11 slides

SELECT c.cid, a.aid, p.pid FROM Cust AS c, Ag AS a, Prod AS p

a:. SELECT c.cid, a.aid, p.pid FROM Cust AS c, Ag AS a, Prod AS p WHERE c.city = a.city AND a.city = p.city. b:. SELECT c.cid, a.aid, p.pid FROM Cust AS c, Ag AS a, Prod AS p WHERE c.city <> a.city OR a.city <> p.city. c:. SELECT c.cid, a.aid, p.pid FROM Cust AS c, Ag AS a, Prod AS p

139 views • 6 slides

80 views • 0 slides