SQL Lec-9 : SQL Select TOP Query | Database Management System #sql #selecttoprecords #dbms #sqlquery
Description
The SELECT TOP statement returns a specified number of records.
SELECT TOP is useful when working with very large datasets.
Non SQL Server databases use keywords like LIMIT, OFFSET, and ROWNUM.
The general syntax is: SELECT TOP n column-names FROM table-name
SELECT TOP 10 Id, ProductName, UnitPrice, Package FROM Product
ORDER BY UnitPrice DESC
Follow us on Facebook : https://www.facebook.com/neevika/
Next SQL Lec-10 : https://youtu.be/8KOz49vAYMQ
Previous SQL Lec-8 : https://youtu.be/E-s7JfrqVYY
Comments