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 21560how 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 18069i 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 10082Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1990Post New HCL SQL Server Interview Questions
Tell me what is use of except clause? How it differs from not in clause?
What are the advantages of mysap crm over r/3?
What is the command for archiving a group of files in hdfs.
Does java arraylist maintain insertion order?
How do you enter data into a spreadsheet?
Explain what are the drawbacks of Joomla?
What is Collation Sensitivity ? What are the various type ?
If the test case frame contains several test cases, how can one execute just the selected one of those test cases?
Explain what is the difference between links and multi value links?
How secure is blockchain? Have they even be hacked?
What Are the Main Features of SQL Azure?
What is the rate of basic excise duty and specific duty And I want to know that how can I see that vat rate in up ,excise duty and tds details Please tell me site plese
What are the different tasks we can perform managing host using ambari host tab?
What is the resulting solution when benzene and toluene are mixed ?
how can you describe the relationship between a flexible management topology and the network deployment cell?