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 20549how 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 17673i 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 9659Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1903Post New HCL SQL Server Interview Questions
How aggregation of data works in tableau?
what is the organisation chart for accounting and finance ?
Explain benefits of lazy evaluation in RDD in Apache Spark?
Is arch linux good?
Is sucuri safe?
What is css in html?
Can you use variables in css?
Caffeine standard is recommended by the monograph for HPLC wavelength accuracy calibration. It is covered range of 205 to 273 only.If the method have wavelength beyond the range, then how it supports for instrument performance?
What is the difference between uipath and selenium?
What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary
What is functional interface in java example?
What is mutex in an embedded system?
Katari your questions was really helpful could you please send the questions and answers with them . Can anyone sends the top 30-40 question and answers for the interview purposes
Explain me why are all the comments being moderated?
What are the different components of typescript?