Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Write a SQL Query to show last records from a table. 

Pooja Goel  |   Nov 12, 2019  |  Views: 251

Description:

There is sample data in below table “Employee”




Method 1:

 

The Query is :

 

SELECT TOP 1 * FROM Employee ORDER BY ID DESC

 

Method 2:

 

The Query is :

 

SELECT * FROM Employee WHERE id=(SELECT max(id) FROM Employee)

Output :




Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Read related articles

Write a SQL query using Exists

Pooja Goel  |   Dec 7, 2019  |  Views: 334

Write a SQL query to set default value

Pooja Goel  |   Dec 7, 2019  |  Views: 257

Write a SQL query to set current date

Pooja Goel  |   Dec 7, 2019  |  Views: 247

Write a SQL query to exclude first n records

Pooja Goel  |   Dec 7, 2019  |  Views: 196

Write a SQL query to convert date into string.

Pooja Goel  |   Dec 5, 2019  |  Views: 301

Write a SQL query to declare variable with value

Pooja Goel  |   Dec 5, 2019  |  Views: 223

Write a SQL query to rename column in table

Pooja Goel  |   Dec 5, 2019  |  Views: 257

Write a SQL query to add column in table

Pooja Goel  |   Dec 5, 2019  |  Views: 217

Write a sql query using CTE

Pooja Goel  |   Dec 5, 2019  |  Views: 169

Write a sql query to get NULL values

Pooja Goel  |   Dec 5, 2019  |  Views: 185

Write a SQL query using WHERE 1=1 statement in sql

Pooja Goel  |   Dec 5, 2019  |  Views: 176

Write a SQL query that uses the having clause.

Pooja Goel  |   Dec 5, 2019  |  Views: 136

Write a sql query to replace substring.

Pooja Goel  |   Dec 5, 2019  |  Views: 161

Write a SQL query using Logical Operator.

Pooja Goel  |   Dec 5, 2019  |  Views: 151

Write a SQL query using Joins.

Pooja Goel  |   Dec 5, 2019  |  Views: 161

Write a SQL query to delete a table.

Pooja Goel  |   Dec 5, 2019  |  Views: 146

Write a SQL query using MIN function in sql server

Pooja Goel  |   Dec 5, 2019  |  Views: 155

Write a SQL query to add two strings or words.

Prashant Surya  |   Nov 15, 2019  |  Views: 237

Write a SQL query to display all triggers

Pooja Goel  |   Nov 15, 2019  |  Views: 180

Write a SQL query to display all procedures.

Pooja Goel  |   Nov 15, 2019  |  Views: 202

Write a SQL Query to show first rows of a table.

Pooja Goel  |   Nov 12, 2019  |  Views: 235

Write a SQL Query to copy New Table From Table.

Pooja Goel  |   Nov 12, 2019  |  Views: 247

Write a SQL Query to Alias the Column of the table.

Pooja Goel  |   Nov 12, 2019  |  Views: 271

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale