Posts

How to find Nth highest salary in ms sql server

some guys confused how to write a query for getting output in sql server. there are so many way to get Nth salary .......... i am explaining two ways below find : select * from (select  Dense_Rank() over (order by salary  desc) as denserank,salary from SalaryMaster) as r where denserank= Value  Value=on which position rank you want i.e. 2 or 5th this is a Dense_Rank() function which gives you a sequence without skipping a number order. this is the best way to get Nth salary in a query. -------------------------------------------------------------------- 2nd way.  with CTE with CTESalary AS ( Dense_Rank() over (order by salary desc)as denserank, ,salary from SalaryMaster ) select * from CTESalary where denserank=2 
Post a Comment
Read more

iphone review

<iframe style="width:120px;height:240px;" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" src="//ws-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=IN&source=ac&ref=tf_til&ad_type=product_link&tracking_id=cseindia-21&marketplace=amazon&region=IN&placement=B01NCN4ICO&asins=B01NCN4ICO&linkId=d39f0222a89bd1714f411d1b6fcc047a&show_border=false&link_opens_in_new_window=false&price_color=333333&title_color=0066c0&bg_color=ffffff">     </iframe>
Post a Comment
Read more

Unable to add google gmail in iphone

Hello guys,                  i deleted my account and tried to add again but i was facing problem when i was entering my username and password then screen was flashing once then again go to choose option screen .  solution is you'll get micro second to save your setting . when you entered your details then screen will show save button upper right corner. then quickly press save button and you'll see your account has been added. thnx . hope it'll helpful.
Post a Comment
Read more

Understanding ASP.NET MVC using real world example, for beginners and intermediate

Image
ASP.NET MVC First thing is to understand the ASP.NET MVC framework itself, once we’ve gotten enough understanding of the ASP.NET MVC framework, then it would be a lot easy for us to understand why ASP.NET team provided us with this framework. In web development, there are different schemes used to create web sites and web applications, which at a minor age don’t seem to cause a problem. Solving a bug might take hours of headscratching and some other help too. It is harder to find the problem that is scripted inside the HTML web page. In these scenarios, it is always found helpfull to seperate your code from your data and from your HTML markup. This would make it a lot easier to find and solve the problem. Because, now all of the code has been seperated and finding the problem at exact location won’t be a harder task. These three fields are divided and make up the MVC; Model, View and Controller pattern for web development. Actually this is not a pattern, specific to the web dev
Post a Comment
Read more

(nested gridview):How to Get parent gridview rowindex on a child gridview link button click

 GridViewRow Gv2Row = (GridViewRow)((LinkButton)sender).NamingContainer; GridView Childgrid = (GridView)(Gv2Row.Parent.Parent); GridViewRow Gv1Row = (GridViewRow)(Childgrid.NamingContainer); int b = Gv1Row.RowIndex;
Post a Comment
Read more

how to get list of tables, functions and stored procedure created last month in sql server

SELECT         [name]        ,create_date        ,modify_date FROM         sys.tables where create_date >='03/01/2015'                                         SELECT * FROM sys.procedures WHERE  create_date >='03/01/2015' SELECT * FROM sys.objects WHERE type IN ('FN', 'IF', 'TF')  -- scalar, inline table-valued, table-valued
Post a Comment
Read more

how to get files from google drive

<head runat="server">     <meta http-equiv="content-type" content="text/html; charset=utf-8" />     <title>Google drive attachment Example</title>     <script type="text/javascript" src="https://apis.google.com/js/api.js?onload=onApiLoad"></script>     <script type="text/javascript">         function onApiLoad() {             gapi.load('auth', { 'callback': onAuthApiLoad });             gapi.load('picker');         }         function onAuthApiLoad() {             window.gapi.auth.authorize({                 'client_id': '376407259412-3m7pu8htrdvf2u2tt9flm9o8pftioqj6.apps.googleusercontent.com',                 'scope': ['https://www.googleapis.com/auth/drive']             }, handleAuthResult);         }         var oauthToken;         function handleAuthResult(authResult) {             if (authResult && !
Post a Comment
Read more