Click here to Skip to main content
14,933,538 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get all reference of a column in a database. Pin
Nagy Vilmos2-Aug-11 22:24
professionalNagy Vilmos2-Aug-11 22:24 
AnswerRe: How to get all reference of a column in a database. Pin
UNCRushFan3-Aug-11 1:43
MemberUNCRushFan3-Aug-11 1:43 
GeneralRe: How to get all reference of a column in a database. Pin
digvijay dobhal3-Aug-11 1:51
Memberdigvijay dobhal3-Aug-11 1:51 
AnswerRe: How to get all reference of a column in a database. Pin
Shameel3-Aug-11 2:05
professionalShameel3-Aug-11 2:05 
GeneralRe: How to get all reference of a column in a database. Pin
UNCRushFan3-Aug-11 2:13
MemberUNCRushFan3-Aug-11 2:13 
GeneralRe: How to get all reference of a column in a database. Pin
digvijay dobhal3-Aug-11 2:42
Memberdigvijay dobhal3-Aug-11 2:42 
Questionmysql SELECT WHERE Pin
samson radu2-Aug-11 1:33
Membersamson radu2-Aug-11 1:33 
AnswerRe: mysql SELECT WHERE Pin
Luc Pattyn2-Aug-11 2:02
sitebuilderLuc Pattyn2-Aug-11 2:02 
the concept of first row/last row does not exist, unless you have an ORDER BY clause, without that the rows are unordered i.e. they come in an arbitrary order.

So whatever criterion it is you want to define the "last rows", write the inverse and use LIMIT(n) or TOP(n) to get the first N rows of that. Use TOP in T-SQL, LIMIT in MySQL.

Smile | :)
Luc Pattyn [My Articles] Nil Volentibus Arduum

GeneralRe: mysql SELECT WHERE Pin
samson radu2-Aug-11 2:20
Membersamson radu2-Aug-11 2:20 
AnswerRe: mysql SELECT WHERE Pin
Luc Pattyn2-Aug-11 2:28
sitebuilderLuc Pattyn2-Aug-11 2:28 
GeneralRe: mysql SELECT WHERE Pin
samson radu2-Aug-11 2:44
Membersamson radu2-Aug-11 2:44 
GeneralOrder by Pin
David Mujica2-Aug-11 2:44
MemberDavid Mujica2-Aug-11 2:44 
GeneralRe: Order by [modified] Pin
samson radu2-Aug-11 2:52
Membersamson radu2-Aug-11 2:52 
GeneralRe: Order by Pin
PIEBALDconsult2-Aug-11 2:57
professionalPIEBALDconsult2-Aug-11 2:57 
GeneralRe: Order by Pin
samson radu2-Aug-11 3:06
Membersamson radu2-Aug-11 3:06 
AnswerRe: mysql SELECT WHERE Pin
Nagy Vilmos2-Aug-11 22:27
professionalNagy Vilmos2-Aug-11 22:27 
QuestionError trapping in SQL Server 2005 [modified] Pin
vanikanc1-Aug-11 7:37
Membervanikanc1-Aug-11 7:37 
AnswerRe: Error trapping in SQL Server 2005 Pin
jschell1-Aug-11 8:25
Memberjschell1-Aug-11 8:25 
GeneralRe: Error trapping in SQL Server 2005 Pin
vanikanc1-Aug-11 8:29
Membervanikanc1-Aug-11 8:29 
GeneralRe: Error trapping in SQL Server 2005 Pin
jschell2-Aug-11 9:18
Memberjschell2-Aug-11 9:18 
AnswerRe: Error trapping in SQL Server 2005 Pin
Shameel1-Aug-11 8:59
professionalShameel1-Aug-11 8:59 
AnswerRe: Error trapping in SQL Server 2005 Pin
Mycroft Holmes1-Aug-11 13:01
professionalMycroft Holmes1-Aug-11 13:01 
AnswerRe: Error trapping in SQL Server 2005 Pin
thatraja1-Aug-11 15:00
professionalthatraja1-Aug-11 15:00 
QuestionDynamic sort Pin
vanikanc1-Aug-11 2:54
Membervanikanc1-Aug-11 2:54 
AnswerRe: Dynamic sort Pin
Herman<T>.Instance1-Aug-11 3:15
MemberHerman<T>.Instance1-Aug-11 3:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.