Fetch only the last 5 records from a table?
Asked By
20 points
N/A
Posted on - 06/26/2012
What if I need to fetch only the last 5 records from a table with fields like ID, City, State, and Address? How will I make this possible?
Best Answer
Best Answer
Fetch only the last 5 records from a table?
Hello Barb Brennan!
The answer is pretty easy. You just need to tell the query to order the records/data/information by descending order and get the last five rows. Here's the code: SELECT ID, City, State, Address FROM TABLE ORDER BY DESC FETCH LAST 5 ROWS ONLY; Code explanation: SELECT – select the columns you want to get TABLE – this is the table where you are going to get the records ORDER BY DESC – order the records in descending FETCH LAST 5 ROWS ONLY – will only get the last 5 row records from the table. You can also use FETCH FIRST 10 ROWS ONLY depending on what you want to achieve.
Fetch only the last 5 records from a table?
Hello Barb Brennan,
There is very simple solution for this particular problem
You could use a loop if you are using PL/SQL to fetch only five records
Steps:
1. Firstly arrange the data in descending order or reverse order whatever is applicable.
2. Make a loop which starts from 1 and ends at 5 with one increment.
3. In Body write your code to fetch the 5th row. (Where 1<=i<=5 )
That's It.
Enjoy..:)
Latest Articles
Top Applications Of AI In Military
AI has become an essential part of the military’s functioning. Military teams must keep up with emerging security threats and challenges. With the introduction of Large Language Models and Natural Language Processing, AI offers...
KjøPe Mobil Uten Abonnement Or With A Contract
Mobile phones nowadays are used more in the capacity of a mini laptop than merely for phone or messaging purposes. Many people conduct professional and personal business with the loads of apps available, social...
Is Dream99 Really Reputable?
The question of whether Dream99 is really reputable has received great attention from the gaming community. Join us to learn about this brand through the article below
Is Dream99 Really Reputable?
Dream99 is one of the...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
