How can we use TOP clause and GETDATE() fucntion in sql

The TOP Clause

The TOP clause is used to specify the number of records to return.
The TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

GET DATE()


GETDATE() fucntion returns current date and time from sql server.

eg:- Select Getdate() as currentdatetime