SELECT TOP with Example in SQL

SELECT TOP with Example in SQL

In this past article, we found out about Injection. Presently, in this article we will examine about SELECT TOP in SQL.

SELECT TOP is utilized to restore the quantity of records, it is quick and its presentation is awesome. It is exceptionally valuable for the huge database having a huge number of records.

SELECT TOP is utilized in various manners in various databases.

Syntax:

  • MS Access: select top number column_name from table_name;
  • MS Access: select top percent column_name from table_name;
  • MySQL: select column_name from table_name LIMIT number;
  • Prophet: select column_name from table_name where ROWNUM (<=, >=, ==) number;

Example:

Student_IDStudent_NameDeptBranchCourse
15011Aman GautamCSEITB.tech
15028Atul AnandCSECSB.tech
15032Bharti ParmarCSECSB.tech
15068Partha BiswasCSEITB.tech

SQL Query utilizing Oracle Database:

SELECT TOP with Example in SQL

End:

SELECT TOP with Example in SQLIn this article, we have found out about the SELECT TOP technique to recover information from the database. It is extremely valuable for recovering information from the enormous database. We will find out about SQL in the up and coming article.

DURGESH

I Love python, so I like machine learning a Lot and on the other hand, I like building apps and fun games I post blogs on my website for Tech enthusiast to learn and Share Information With The World.

Leave a Reply

Your email address will not be published. Required fields are marked *

6 − three =

Recent Content