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 21057how 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 17841i 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
Explain benefits of lazy evaluation in RDD in Apache Spark?
How to place comments in pl/sql?
When is the finalize() called?
How do I register a dll file in windows 7?
Give a few applications of bi?
How to implement relationships in hibernate?
Explain the Realisation concept and Accounting concept? why do you prepare p/l appropriation account? 4 difference b/w public and private caompany? How do you calculated closing stock in tradind a/c? Contents an invoice receipt? classification of Error as per accounting? Diff btwn Satutory audit & Internal audit? Diff b/w reserves for bad debts and provision for bad debts? Where the Bank book and the Cash book will not reconcile? When will the Cash book have a credit balance?
What is DevOps cloud?
Why doesn't the following code print the newline properly?
Explain two-phase locking protocol.
How to include css inside the head tag?
How do carnivorous plants digest their food?
What are triggers in DB? Explain their types. How do they work?
What are the differences between star and snowflake schema?
A man is travelling with the speed of 10m/min across the river to the opposite bank.The river water flows at the speed of 1m/s.Since the water flows at the speed higher than the boatsman, he would definitley reach the opposite river bank in a slant path.What is the length of the path he travelled?. The river is 10m wide. Please give me solution to tha above probelm. Thanks in advance