Answer / suresh jp

select emp_no,max(salary) over() from table_employee;

Answer / nitin sane

select Employee_name,max(Employee_Salary) over() from Employee_test;

Answer / mithilesh gatole

Answer -

select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )

How to add an address record into adventureworkslt?

0 Answers  

---

What is temporary stored procedure?

0 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

What is named calculation? : sql server analysis services, ssas

0 Answers  

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

what are acid properties? : Sql server database administration

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

Can we use where and having clause together?

0 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---