Home
|
Tech FAQ
|
Interview Questions
|
Placement Papers
|
Tech Articles
|
Learn
|
Freelance Projects
|
Online Testing
|
Geeks Talk
|
Job Postings
 |
Knowledge Base
 |
Site Search
|
Add/Ask Question
GeekInterview.com
>
Tech FAQs
>
SQL
Print
|
Question
:
What is the Querry for retrieving the 2nd highest salary in a table?
March 03, 2006 04:55:46
#4
BitlaPavanKumar
J2EE Expert
Member Since: February 2006 Total Comments: 2
RE: What is the Querry for retrieving the 2nd highest ...
The Query is:
SELECT
MAX
(
SAL
)
AS
SAL
FROM
EMPLOYEE
WHERE
SAL
<>(SELECT
MAX
(
SAL
)
FROM
EMPLOYEE
)
Back To Question