SQL basics Flashcards by A Rajkumar

{ "@context": "https://schema.org", "@type": "Organization", "name": "Brainscape", "url": "https://www.brainscape.com/", "logo": "https://www.brainscape.com/pks/images/cms/public-views/shared/Brainscape-logo-c4e172b280b4616f7fda.svg", "sameAs": [ "https://www.facebook.com/Brainscape", "https://x.com/brainscape", "https://www.linkedin.com/company/brainscape", "https://www.instagram.com/brainscape/", "https://www.tiktok.com/@brainscapeu", "https://www.pinterest.com/brainscape/", "https://www.youtube.com/@BrainscapeNY" ], "contactPoint": { "@type": "ContactPoint", "telephone": "(929) 334-4005", "contactType": "customer service", "availableLanguage": ["English"] }, "founder": { "@type": "Person", "name": "Andrew Cohen" }, "description": "Brainscape’s spaced repetition system is proven to DOUBLE learning results! Find, make, and study flashcards online or in our mobile app. Serious learners only.", "address": { "@type": "PostalAddress", "streetAddress": "159 W 25th St, Ste 517", "addressLocality": "New York", "addressRegion": "NY", "postalCode": "10001", "addressCountry": "USA" } }

What does SELECT do?

The feilds that you want the query to return/display data from

How well did you know this?

Not at all

Perfectly

What does FROM do?

Specify the names of the tables where the data is to be retrieved from

How well did you know this?

Not at all

Perfectly

What does WHERE do?

Enter your search criteria which the returned recods have to match

How well did you know this?

Not at all

Perfectly

What does ORDER BY do?

Enter the field name that you want to order the results by the end in what order (ASC/DESC)

How well did you know this?

Not at all

Perfectly

SQL basics Flashcards

(4 cards)