Click here to Skip to main content
15,907,281 members
Home / Discussions / Database
   

Database

 
Questionproblem in page indexing in Grid View Pin
ahmed_fci200610-Oct-07 0:44
ahmed_fci200610-Oct-07 0:44 
QuestionLast value in a Table Pin
BINOVAR10-Oct-07 0:18
BINOVAR10-Oct-07 0:18 
AnswerRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:32
Aavesh Agarwal10-Oct-07 0:32 
GeneralRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:36
Aavesh Agarwal10-Oct-07 0:36 
AnswerRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 0:56
Paddy Boyd10-Oct-07 0:56 
GeneralRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 1:11
Paddy Boyd10-Oct-07 1:11 
GeneralRe: Last value in a Table Pin
BINOVAR10-Oct-07 1:09
BINOVAR10-Oct-07 1:09 
GeneralRe: Last value in a Table Pin
pmarfleet10-Oct-07 2:12
pmarfleet10-Oct-07 2:12 
One of the fundamental principles of a relational database is that the physical order of rows and columns in the tuples (tables) is not important.

http://en.wikipedia.org/wiki/Relational_database[^]

If you need to extract data in a particular order, the data itself should provide the means of doing this. For instance, if you had an numeric EmployeeID field which was incremented every time a new employee joined the company then you could find the last value in your table by selecting the row of data with the highest EmployeeID value. You don't have any data items that you can use for this purpose in your table so you can't achieve this.

Paul Marfleet

QuestionQuery regarding Trigger Pin
Aavesh Agarwal9-Oct-07 23:37
Aavesh Agarwal9-Oct-07 23:37 
QuestionSwap the columns values [modified] Pin
Aavesh Agarwal9-Oct-07 22:55
Aavesh Agarwal9-Oct-07 22:55 
AnswerRe: Swap the columns values Pin
Joe9-Oct-07 23:26
Joe9-Oct-07 23:26 
GeneralRe: Swap the columns values Pin
Aavesh Agarwal9-Oct-07 23:28
Aavesh Agarwal9-Oct-07 23:28 
Questionproblem in a tipical query(plzzz help me) Pin
Arihant rathi9-Oct-07 20:57
Arihant rathi9-Oct-07 20:57 
AnswerRe: problem in a tipical query(plzzz help me) Pin
joemonvarghese9-Oct-07 22:32
joemonvarghese9-Oct-07 22:32 
GeneralRe: problem in a tipical query(plzzz help me) Pin
Arihant rathi10-Oct-07 0:28
Arihant rathi10-Oct-07 0:28 
GeneralRe: problem in a tipical query(plzzz help me) Pin
pmarfleet10-Oct-07 1:55
pmarfleet10-Oct-07 1:55 
GeneralRe: problem in a tipical query(plzzz help me) Pin
joemonvarghese10-Oct-07 3:46
joemonvarghese10-Oct-07 3:46 
QuestionMySQL:(urgent)Why reader.Close() hangs if a LONGBLOG field is selected? [modified] Pin
alesh_nitre9-Oct-07 20:50
alesh_nitre9-Oct-07 20:50 
QuestionColumn with Null value Pin
Mri1a9-Oct-07 20:28
Mri1a9-Oct-07 20:28 
AnswerRe: Column with Null value Pin
Mri1a9-Oct-07 20:40
Mri1a9-Oct-07 20:40 
AnswerRe: Column with Null value Pin
M LN Rao9-Oct-07 20:47
M LN Rao9-Oct-07 20:47 
AnswerRe: Column with Null value Pin
Paddy Boyd10-Oct-07 1:00
Paddy Boyd10-Oct-07 1:00 
QuestionThe maximum no. of Stored procedure in a database. Pin
Vipin.d9-Oct-07 19:54
Vipin.d9-Oct-07 19:54 
AnswerRe: The maximum no. of Stored procedure in a database. Pin
Paul Conrad3-Nov-07 7:52
professionalPaul Conrad3-Nov-07 7:52 
QuestionConcatenating Columns in query Pin
anujose9-Oct-07 19:05
anujose9-Oct-07 19:05 

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.