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 16839how 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 15938i 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 8203Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1465Post New HCL SQL Server Interview Questions
What is the g value paradox?
Why can't we have instance(stack) of a class as a member of the same class like eg.Class A{A obj;} as we can have self refential pointer
Concerning enzymatic reactions how different, are the graphic curve of the variation of the speed of a reaction as function of substrate concentration and the curve of variation of the speed of a reaction as function of temperature?
How do you create staff assignments?
Explain how can you separate hydrogen peroxide into hydrogen and oxygen?
What is 'custom duty'?
Suppose the price elasticity of demand for the textbooks is two and the price of the textbook is increased by 10% By how much does the quantity demand fall? Enter the results and discuss reason for the fall in quantity demand.
i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status
What is maven and what is jenkins?
Types of F/w in Automation
Explain what is a view?
What is application server node?
What is a recursive join sql?
How can Server Hang be solved?
How to use filtering in xslt? : xslt