Answer / gaurav singh 'viccky'

select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))

Answer / arjunraj

aa means table-alias name
bb means table-alisa name

select * from emp aa where 2=(select count(distinct empsalary) from emp bb where aa.empsalary<=bb.empsalary)

Answer / dakshin

select * from (select a.*,dense_rank() over (order by sal) rnk from emp a order by sal) where rnk =2

Answer / kishor dange

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Answer / vikas

select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary

Answer / ashwini

select max(salary) from employee where salary < (select max(salary) from employee)

Answer / manjusha

select * from emp e1
where 2=(select count(distinct salary) from emp e2
where e1.sal<e2.sal);

Answer / hari thorat

select max(salary) from employee where salary <(select max(salary) from employee);

Answer / gunjal ghagre

Select sal from table_name order by sal desc limit 1,1;

Answer / debasish

select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

Differentiate between pl/sql and sql?

0 Answers  

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  

Can we create table inside stored procedure?

0 Answers  

How show all rows in sql?

0 Answers  

Why we use triggers in mysql?

0 Answers  

What are the different types of database management systems?

0 Answers  

What is ROWID?

8 Answers  

Explain the advantages and disadvantages of stored procedure?

0 Answers