In MS SQL Server i can do this:
SELECT
Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub
INTO #tempfemale
FROM Aviation.Crew
WHERE Sex = 'F'
InterSystems Caché is a multi-model DBMS and application server. See more details here.