SQL QUERY [message #11231] |
Mon, 15 March 2004 01:54 |
ADHISH KUNDU
Messages: 2 Registered: March 2004
|
Junior Member |
|
|
I want to reterieve the middle most job_id of an employee table,Please tell me the sql query regarding that.
Further I also want to reterieve details of a job_id relating to row number e.g I want to reterieve 13th row from the top or from the bottom. The table name is employee.
Please tell me query regarding that.
|
|
|
Re: SQL QUERY [message #11237 is a reply to message #11231] |
Mon, 15 March 2004 05:40 |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
What if there are an even number of rows, which job_id should be returned then?
Also, what criterion are you using to ORDER BY here? So when you say, "I want to retrieve details of a job_id relating to row number e.g I want to retrieve 13th row from the top or from the bottom", with regards to what? Because without some order that you impose, there is no such thing as "the thirteenth row of a table".
Get back to us,
Art.
|
|
|