finding a values from a table ?

Accepted answer

Hello,

Ans 1 :

SELECT MAX(SALARY) FROM EMPLOYEE

WHERE SALARY NOT IN (SELECT MAX(SALARY) FROM EMPLOYEE)

Ans 2:

SELECT * FROM EMPLOYEE

WHERE COMPANY=SPOUCECOMPANY

Dear Piyush, thankyou for ur help ,and thaks for ur quick reply.. thanks and Regards prasad bhagat

Hi try this

Select e.Id,e.EmpName,d.DeptName,e.Salary from Employee e inner join Dept d on e.Id=d.Id

answer 1:

SELECT top 1 MAX(salary) FROM Table_3

WHERE salary NOT IN (SELECT MAX(Salary) FROM Table_3 )

answer2:

SELECT distinct a.name ,a.spouce

FROM Table_3 a, Table_3 b

WHERE a.company = b.spoucecompany

Hi

Try this.

select top 1 salary from (select distinct top 2 salary from Employee order by Salary desc) emp order by Salary asc

If ok accept this.