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 21163how 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 17909i 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 9919Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1952Post New HCL SQL Server Interview Questions
What are the most important skills of the person who does this job?
What is data import in r language?
How can we identify the resources for which the sessions are waiting?
How can I make my site public? By default, all sites are created private at sharpoint?
Explain about the functions strcat() and strcmp()?
Where is zoom button?
Difference between Mitsui MAN and Hitachi MAN?
List out configuration options available in backbone js?
Is constructor a static method?
What permissions are required to perform stsadm operations?
What do you mean by after treatment?
What is an anonymous method and how is it different from a lambda expression?
What is activex installer?
What is a class loader?
What is windows form application?