Answer / sowjanya

Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)

Answer / trived

select * from emp
where n-1 = (select count(*) from emp e
where emp.salary<e.salary)

in place of n-1 you can keep zero for first hight salary
and 1 for second hightest salary.....etc

Answer / rony sunny

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / ravikumar

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2

Answer / balindra sahani

select max(sal) from emp
where sal not in (select max(sal) from emp )

Answer / karna

select top 1 a.salary,* from emp a
where a.salary not in(select top (n-1) b.salary from emp b)

here n is the Nth values:if you want secong highest: keep n
as 2 so the query will become

select top 1 a.salary,* from emp a
where a.salary not in(select top 1 b.salary from emp b)

Answer / balindra sahani

select max(sal) from emp
where sal not in (select max(sal) from emp order by sal desc )

Answer / mithilesh mishra

Select Max(sal) from emp where sal not in (select max(sal)
from emp)

Answer / vivek mohan singh

select salary from tablename order by salary desc limit 1,1;

How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  

What is database design and development?

0 Answers  

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

Write short notes on XSU and JAVA

1 Answers  

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

0 Answers  

In which database can extended stored procedures be added?

0 Answers  

What is the system function to get the current user's user id?

4 Answers  

what is difference between primary key and unique key ?

2 Answers  

Explain about post-relational databases?

0 Answers