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 )

List the different types of joins?

0 Answers  

---

Do you know the cursor types?

0 Answers  

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

internal language used in sql server 2000?

2 Answers  

---

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

What is the difference between push and pull subscription? : sql server replication

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---