how to find latest entry in table using sql query

Question

1.44/5 (2 votes)

See more:

SQL-Server-2008R2

SQL

cmd.CommandText = "SELECT  distinct GLMAST.fglhead,MAINFILE.facno,max(MAINTRAN.fdate) as fdate ,max(MAINTRAN.fbalance) as fbalance  FROM MAINTRAN INNER JOIN MAINFILE ON  MAINFILE.facno like MAINTRAN.facno INNER JOIN MASTERID ON  MAINFILE.fmasterno like MASTERID.fmasterid  INNER JOIN  GLMAST ON GLMAST.fglcode like  LEFT(MAINFILE.facno,9) and   GLMAST.fglhead = '" & ComboBox2.Text & "' and MAINTRAN.fdate<='" & Format(prdate, "MM/dd/yyyy") & "' " & _
                                          "where MAINTRAN.fbankcode='" & "010" & "'" & _
                                         "and MAINTRAN.fdate<='" & Format(prdate, "MM/dd/yyyy") & "' " & _
                                         "and MAINTRAN.fbranchcode='" & "01" & "' group by MAINFILE.facno,GLMAST.fglhead "

VB

With cmd
dr = .ExecuteReader
End With

If dr.HasRows = True Then
Do While dr.Read
presentdaybal = dr!fbalance
Loop
dr.Close()

Posted 26-Nov-14 19:51pm

lakshjoshi

Add a Solution

Comments

Richard Deeming 27-Nov-14 13:57pm

Your code is vulnerable to SQL Injection[^].

NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

2 solutions

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)

Maciej Los · Answer 1 · 2014-11-26T20:14:00

Direct after insertion, use @@identity[^] property, which returns last inserted identity value.

Do not use queries in code behind. It might be the reason of SQL Injection[^]. Use stored procedure[^] instead.

Sql Server - How to write a Stored procedure in Sql server[^]
Walkthrough: Using Only Stored Procedures (Visual Basic)[^]

/\jmot · Answer 2 · 2014-11-27T07:33:00

how to find latest entry in table using sql query?? okk.

if you want to select the latest entry in your sql table then use

SQL

@@Identity,@Identity_scope,@@Identity_current

(search Google for more clarification)
it works if the table has identity column(AI)

or

don't have the identity column but has a Date column(insertion Date)

SQL

select top 1 * from Table_Name order by  Date_column desc

if you have any other problem to fetching result then be more specific next time when posting any question.

you can update posted question using improve question link.

how to find latest entry in table using sql query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0