TOP HACK π₯π₯π₯ #sql #top #datascience #sorting #dataengineering #dataanalytics #sqlserver #data
Details
| Title | TOP HACK π₯π₯π₯ #sql #top #datascience #sorting #dataengineering #dataanalytics #sqlserver #data |
| Author | The SQL Hero |
| Duration | 0:12 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=8QTWcWeLXpk |
Description
Sometimes we want to retrieve a specific number of records from the SQL table rather than retrieving all table records. We can use the WHERE clause in a SELECT statement to limit the number of rows. Suppose you have a customer table and you want to retrieve records for customers belonging to a particular country. There might be many records satisfying the condition. We require top βNβ customer records to satisfy the conditions. For this requirement, we can use TOP or ROW_Number() clauses.
TOP (expression) - Limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server. When you use TOP with the ORDER BY clause, the result set is limited to the first N number of ordered rows. Otherwise, TOP returns the first N number of rows in an undefined order. Use this clause to specify the number of rows returned from a SELECT statement. Or, use TOP to specify the rows affected by an INSERT, UPDATE, MERGE, or DELETE statement.
π₯PLEASE LIKE and SUBSCRIBEπ₯ - this will boost our motivation to create even more amazing videos.
Be a SQL HERO!
TOP HACK π₯π₯π₯ #sql #top #datascience #sorting #dataengineering #dataanalytics #sqlserver #data
