Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'last' function for Oracle pass-though

Status
Not open for further replies.
dan626mcl2

dan626mcl2

Technical User
Jul 17, 2003
2
0
0
US
Can anyone give me an SQL example of how I can pull the last row of data in an Oracle pass-though?

thx
 
Sort by date Sort by votes
In SQL,usually we make use of order by some column name and put desc at the end.
ex.

select top 1 * from MyTable order by col1 desc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
357
mikrom
mikrom
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
104
Andrzejek
Andrzejek
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
79
briangriffin
briangriffin
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
105
Andrzejek
Andrzejek
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
141
JohnBayne
JohnBayne

Part and Inventory Search

Sponsor

Back
Top