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 16957how 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 16031i 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 8291Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1485Post New HCL SQL Server Interview Questions
What is the use of applicationcontextaware in spring?
What is the difference between copies & retain in iOS operating system?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
what are the use of belew gear in general ??
Explain the Mates receipt?
Why does the present vlsi circuits use mosfets instead of bjts?
What is maven project?
In android, which method you can use to obtain the path of the external storage?
Can you explain the difference between a validation set and a test set?
What is analytical snapshot in salesforce.com ? : salesforce admin
How to resolve small file problem in hdfs?
What are the name and the uid of the administrator user?
Tell me what are the responsive design patterns?
how to do Restricting nodes and Hierarchies through characteristic values and authorization objects
What are cookies?