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 17043how 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 16055i 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 8321Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1489Post New HCL SQL Server Interview Questions
What is classful and classless routing?
write a test case flipkart login page
How do I number pages in ms word?
Explain what is bonded warehouse?
Uses cases for Sharing Rules in salesforce?
How do I keep a table from splitting in word?
What is meant by class and object in java?
Is javascript case sensitive language?
How do i find out the number of parameters passed into function?
What is build interval period?
What is the need for an infinite loop in embedded systems?
What do you mean by optimistic locking?
When should one use mean absolute error over root mean square error as a performance measure for regression problems?
What is phony in makefile?
Is hashset serializable c#?