# SQL Database Sample Comparison

**URL:** <https://forum.inductiveautomation.com/t/sql-database-sample-comparison/71317>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [March 20, 2023, 4:28pm UTC](https://forum.inductiveautomation.com/t/sql-database-sample-comparison/71317 "2023-03-20T16:28:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![R\_P](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@R\_P](https://forum.inductiveautomation.com/u/R_P)\
**Post date:** [March 20, 2023, 4:28pm UTC](https://forum.inductiveautomation.com/t/sql-database-sample-comparison/71317/1 "2023-03-20T16:28:28Z")

</div>

Hi All

I want compare last 3 sample from SQL database in ascending option (1st\>2nd\>3rd)

I want to generate alarm based on this in Ignition Vision System

Anybody has tried before this

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 20, 2023, 5:01pm UTC](https://forum.inductiveautomation.com/t/sql-database-sample-comparison/71317/2 "2023-03-20T17:01:07Z")

</div>

Not much to go on. In most applications the db syntax would be something like this to get the latest three rows (May differ according to db type):

```sql
SELECT *
FROM myTable
WHERE some_column = 'some unique attribute'
ORDER BY t_stamp desc
LIMIT 3

```