Answer / manish nautiyal

select salary from table_name order by salary desc limit 3;

Answer / priya

select top 1 salary from ( select top 3 salary from ( select
distinct salary from employee order by desc ) order by asc);

Answer / john peter

select salary from tablename order by salary desc limit 3;

Answer / m gangadhar

select * from (select a.* from employees a order by
a.salary desc) where rownum <= 5

Answer / saraswathi muthuraman

SQL> desc emp_test;

Name
-----
EMP_NO SAL
DEP_NO

SQL> select * from emp_test;

1001 10000 11
1001 10000 11
1002 100 11
1003 20010 11
1004 99 11
1005 50 11
1006 25 11

SQL> select a.EMP_NO,a.SAL,a.DEP_NO from emp_test a, (select
SAL,rank() over(order by sal desc) as rank_val from emp_test
group by sal)b where
2 a.sal=b.sal and b.rank_val =3;

1002 100 11

1 row selected.

Answer / saraswathi muthuraman

The previous post is to find the 3rd highest value.

Please find the below qry to find the top 3 highest salary

SQL> select a.EMP_NO,a.SAL,a.DEP_NO from emp_test a, (select
SAL,rank() over(order by sal desc) as rank_val from emp_test
group by sal)b where
2 a.sal=b.sal and b.rank_val <=3;

1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11

4 rows selected.

Answer / satya

SELECT salary FROM emp order by ordering DESC limit 2,1

Answer / lokesh das

Using a single query not sub-query

SELECT * FROM `employee` ORDER BY salary DESC LIMIT 2, 1

Answer / ankammarao.v

select min(EmpSal) as sal3 from EmpInfo
where EmpSal in(select distinct top 3 EmpSal from Empinfo
order by EmpSal desc)

How many tables will create when we create table, what are they?

5 Answers  

How do you index just the first four bytes of the column?

2 Answers  

What is mysql port?

0 Answers  

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

0 Answers  

What is mysql57?

0 Answers  

What is innodb_buffer_pool_size?

0 Answers  

mysql> select * from store; +------+-------+-------+ | id | month | sales | +------+-------+-------+ | 1 | 1 | 100 | | 1 | 2 | 100 | | 1 | 3 | 200 | | 1 | 4 | 300 | | 1 | 5 | NULL | | 1 | 6 | 200 | | 1 | 7 | 800 | | 1 | 8 | 100 | | 1 | 9 | 240 | | 1 | 10 | 140 | | 1 | 11 | 400 | | 1 | 12 | 300 | | 2 | 1 | 300 | | 2 | 2 | 300 | | 2 | 3 | 300 | | 2 | 4 | 200 | | 2 | 5 | 200 | | 2 | 6 | 200 | | 2 | 7 | 100 | | 2 | 8 | 100 | | 2 | 9 | 300 | | 2 | 10 | 100 | | 2 | 11 | 150 | | 2 | 12 | 150 | +------+-------+-------+ this is my table. i need to display output like this. +------+----------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | quarter4 | +------+----------+----------+----------+----------+ | 1 | 400 | 500 | 1140 | 840 | | 2 | 900 | 600 | 500 | 400 | +------+----------+----------+----------+----------+ what single query i have to write for this. i tried this query and it displays like the below mysql> select id,sum(sales) as quarter1,(select sum(sales) from store where mont h>3 and month<7 ) as quarter2,(select sum(sales) from store where month>6 and mo nth<10)as quarter3 from store where month>0 and month<4 group by id; +------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | +------+----------+----------+----------+ | 1 | 400 | 1100 | 1640 | | 2 | 900 | 1100 | 1640 | +------+----------+----------+----------+ 2 rows in set (0.00 sec) tel me how to rectify it.

2 Answers  

What are the advantages of MySQL when compared with Oracle?

0 Answers  

How can I create database in mysql?

0 Answers  

What is the difference between is null & is not null?

0 Answers  

Can mysql handle big data?

0 Answers  

Which is better mysql or mssql?

0 Answers