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 21058how 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 17843i 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 9870Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1938Post New HCL SQL Server Interview Questions
what is arc flash and what are the hazards involved
Can we use transfer dataset to transfer data in internal table ?
What is mysql57?
What do you mean by metadata in Hadoop?
How does Python handle the memory management?
What is the default view for word?
What is a hard break Point?
What is conditional formula?
What is icollection in c#?
What is liabilities and what all does include in current liabilities?
Explain the uses of a database trigger?
What is the use of xslt
What is alias?
What are the components of debt equity ratio?
How do I open port 1433?