Monthly Archive: December 2014

Dec 18

Jquery Question and Answer part-1

Q1. What are the methods used to provide effects? Ans. Following are effects Methods. Show() Hide() Toggle() FadeIn() FadeOut() Q2. Is jQuery is a JavaScript or JSON library file? Ans. jQuery is a library of JavaScript file and it consists of DOM, event effects and the Ajax functions. Q3. Which command will give a version of jQuery? Ans. The …

Continue reading »

Dec 14

Find the Nth Highest Salary

See on following table records Emp1 Table Emp ID              Salary 1                          10000 2                          25000 3                     …

Continue reading »

Dec 14

Get Record with Highest Amount in Given Hour

We can achieve this approach using join table it self. create table t1(id int, date datetime, amount int) insert into data values (1,’2014-10-11 15:15:00′,150), (2,’2014-10-11 15:20:00′,50), (3,’2014-10-11 18:30:00′,100), (4,’2014-10-11 18:40:00′,10), (5,’2014-10-11 21:10:00′,40), (6,’2014-10-11 21:20:00′,80); Table Structure with data ID         Date                       …

Continue reading »