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 20948how 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 17807i 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 9821Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
1931Post New HCL SQL Server Interview Questions
What is the difference between now() and current_date()?
2. Dry saturated steam at 3.5 bar is expanded through a convergent nozzle to 2.2 bar. The exit area is 5 sq. cm. Calculate the exit velocity and mass flow rate, assuming isentropic expansion and super saturated flow. b) A cast iron cylinder head is fastened to a cylinder of 750mm bore with 12 stud bolts. The maximum pressure inside the cylinder is 3 Mpa. The stiffness of part is thrice the stiffness of the bolt. What should be the initial tightening load so that the point is leak proof at maximum pressure? Also choose a suitable bolt for the above application 2 The propeller shaft of a marine engine is to transmit 600 kW at 1200 rpm, without a significant bending. The efficiency of the propeller is 88% at 32 knots ( 1 knot = 1085 km/hr). If the slenderness ratio is less than 50 and the permissible shear stress should not exceed 65 Mpa. Determine the diameter of shaft. 3 A semi-elliptic leaf spring consists of two extra full-length leaves and six graduated length leaves, including the master leaf. Each leaf is 7.2 mm thick and 65 mm wide. The centre-to-centre distance between the two eyes is 1.3m. The leaves are pre-stressed in such a way that when the load is maximum, stress induced in all leaves are equal to 380 N/mm sq. Determine the maximum force that the spring can withstand
You want to magnetize a metal. How would you do that?
Can jdbc adapter query db tables? Can it insert?
describe slide agglutination test fpr widal
Differentiate between response.expires and response.expiresabsolute?
why we use 19x9x9and 20x10x10 but not other
Why did you leave your job at Buffalo Wild Wings?
Explain about front drive mechanism in vehicle
Is it possible to run a python script as a service in windows? If possible, how?
Device an algorithm for weiler-atherton polygon clipping, where the clipping window can be any specified polygon
Which tags are no longer valid in html5?
Suppose you need not create separate db for every user in ppsft 8.4 onwards. This is possible because of?
What are benefits of Tensorflow over other libraries?
What command is used to interface ethernet into ubuntu cloud?