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 21142how 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 17891i 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 9905Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1942Post New HCL SQL Server Interview Questions
Does python have private variables?
What is Hive Database?
Wt is the receiver str jdbc?
Differentiate between sga and pga.
Why is jdbc better than hibernate?
What are spring mvc annotations?
what are steps for interface? where is exchange rate defined in which table?
How do you upgrade pip?
Explain process spawning?
What do you mean by hash function?
What is difference between getdate and sysdatetime in sql server 2008?
Is 1920x1080 the same as 16 9?
What is dom stand for?
Plz Ask from me New Accounting Questions.
How you will start keyword research? Which tools would you use for doing it?