T-SQL basics
SQL Server uses T-SQL with batches separated by GO.
What you will be able to do
- Use SELECT and WHERE.
- Use TOP for limits.
- Separate batches with GO.
In plain English
SQL Server uses T-SQL with batches separated by GO.
- Use SELECT and WHERE.
- Use TOP for limits.
- Separate batches with GO.
SELECT TOP 10 title, minutes
FROM lessons
WHERE minutes >= 15
ORDER BY minutes DESC;
GOYour turn
EasyExplain it back
Answer from memory: Which clause limits rows in T-SQL?
TEXT · starter
Your answer…Check your understanding before moving on.
Knowledge checkQuestion 1
Which clause limits rows in T-SQL?
Select an answer to continue
Study tools
Make it yours.
Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.
Sign in to save notes and flashcards.Both are private to your account and stay with your progress.
Sign inFinished reading?
Lock in what you just learned.
0%
Mark this lesson complete to save your place and move one step closer to the certificate.