What will be the result ?

Question

0.00/5 (No votes)

See more:

SQL

SELECT TOP 1 * FROM table_Name ORDER BY unique_column DESC

What will be the result:
- last inserted one or
- first one ?

I need last inserted CustomerID.

Posted 15-Sep-15 20:25pm

tiFoysal

Updated 15-Sep-15 22:06pm

Leo Chapiro

v2

Add a Solution

Comments

Awadhendra Tripathi 16-Sep-15 2:37am

Yes it will give you last inserted column.

tiFoysal 16-Sep-15 2:58am

thanks a lot

Mehdi Gholam 16-Sep-15 2:38am

This is SQL not vb.net

tiFoysal 16-Sep-15 2:57am

ohhh yeah you r right..sorry... and thanks for that. :)

3 solutions

Solution 3

last inserted one will be your output

Posted 16-Sep-15 1:15am

RajeshKadam

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2015-09-15T21:22:00

Solution 2

The query explains itself, it returns the whole top row of table_Name ordered, descending, by unique_column. This way you'll get the row having the greatest value of unique_column. If you are inserting unique_column incrementally then, yes, you'll get the last inserted one.

Out of curiosity, why don't you try it?

Posted 15-Sep-15 21:22pm

CPallini

Comments

tiFoysal 16-Sep-15 3:44am

i just taking the backup of database from live server to local

Magic Wonder · Accepted Answer · 2015-09-15T21:01:00

Solution 1

Hi,

Check this...

Order By[^]

Hope this will help you.

Cheers

Posted 15-Sep-15 21:01pm

Magic Wonder