I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000
17 18728how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
6 16851i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2
5 9012Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1686Post New HCL SQL Server Interview Questions
what you mean by artifact,milestone...
Tailored Communication Style Describe an occasion when you have tailored your communication style to deal with a particular situation within your teamWhy was it necessary? What was the other persons role? What did you need to take
What is the format of informatica objects in a repository?
What are directories in unix?
What is parsing a string?
What is the use of string function split(string,array,separator)in AWK?
What is the capm formula?
What is the function of the transport system and workbench organizer?
How mobile computing is different from cloud computing?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
Q A project cost Rs.6,00,000. It yields annually a profit of Rs.80,000. After depreciation of 12.5% p.a.but before tax of 50%.Calculate payback priod.
Write short notes on any three of the following: (i) Domino Effect (ii) Functional and Dysfunctional conflict (iii) Formal and Informal groups (iv) MBO (v) Organizational Culture and Climate
Explain will the peoplesoft internet architecture, now that it embeds bea weblogic and ibm websphere, work with my other corporate web servers and tools?
What is backus-naur form?
What happen if one of the datanodes has much slower cpu?