SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 09-29-2006, 07:20 PM
davinder singh
 
Posts: n/a
Default SQL 92 dialect question:

how to find third highest record from table?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 09-30-2006, 04:40 AM
Dimitar
 
Posts: n/a
Default SQL 92 answer. Re: how to find third highest record from table?

Please, see my answer to question number 47 ([A]here[/a]), which assumed natural ordering on column "a".
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 10-13-2006, 01:03 AM
manithan
 
Posts: n/a
Default MS SQL answer. Re: how to find third highest record from table?

SELECT top 3 columnname FROM tablename
ORDER BY callsanswered DESC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 12-19-2006, 12:57 PM
Dhanalakshmi
 
Posts: n/a
Default SQL 99 answer. Re: how to find third highest record from table?

SELECT TOP 1 *
FROM (SELECT TOP 2*
FROM tablename
ORDER BY columnname DESC)e1
ORDER BY Sal
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find second highest value of a column in a table? ruby SQL - Questions and Answers 27 06-15-2008 09:53 PM
how to find out the 4th highest value from the column? Anoj biradar SQL - Questions and Answers 3 12-05-2007 04:54 AM
How to find second highest value of a column in a table? | SQL? jaheer SQL - Questions and Answers 9 07-24-2007 12:07 PM


All times are GMT. The time now is 09:32 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8