ram murthy


{ City } hyderabad
< Country > india
* Profession * software engineer
User No # 8954
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 12
Questions / { ram murthy }
Questions Answers Category Views Company eMail




Answers / { ram murthy }

Question { Medi Assist, 65283 }

write the query for find the top 2 highest salary in sql
server


Answer

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Is This Answer Correct ?    3 Yes 4 No

Question { 8035 }

How to delete an attribute from the emp table


Answer

we can delete an attribute through delete command.

Is This Answer Correct ?    1 Yes 8 No