:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Microsoft Related >> VB.NET


 Visual Basic interview questions  Visual Basic Interview Questions (615)
 C Sharp interview questions  C Sharp Interview Questions (722)
 ASP.NET interview questions  ASP.NET Interview Questions (1443)
 VB.NET interview questions  VB.NET Interview Questions (150)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (199)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
sql satement for 2nd maximum value
 Question Submitted By :: VB.NET
I also faced this Question!!     Answer Posted By  
# 1
select top 1 * from author where phone < (select max(phone)
from author) order by phone desc
Is This Answer Correct ?    18 Yes 4 No
Archana Chavan
# 2
author is Table name
ID is column name

select top 1 * from author where ID < (select max(ID)
from author) order by ID desc
Is This Answer Correct ?    16 Yes 3 No
Murli D
# 3
select top 1 sal from
( select top 2 sal from test order by sal desc ) as kk order
by sal
Is This Answer Correct ?    8 Yes 2 No
# 4
create table emp with row empsal having the datatype float
and insert some salary
now to get the second max salary
write the sql statement

select max(empsal) from emp where empsal<(select max(empsal)
from emp)
its asubquery
Is This Answer Correct ?    7 Yes 2 No
# 5
Rohan answer given by you was not working..... 
Is This Answer Correct ?    6 Yes 3 No
# 6
Hey guys use this query ,i used it so many time ,it will be
useful to you..try this one...

SELECT MAX(Salary) AS Expr1
FROM Employees
WHERE (Salary <
FROM Employees))
Is This Answer Correct ?    3 Yes 1 No
Sanjeev Singla
# 7
select Amount from T2 where Amount = ( select max(Amount)
from T2 where Amount < ( select max(Amount) from T2 ))
Is This Answer Correct ?    3 Yes 3 No
Ramavtar Rajput
# 8
select distinct top 2 salary from employee order by salary
Is This Answer Correct ?    3 Yes 3 No
# 9
select top 1 UnitsInStock
from products
where UnitsInStock in (select top 2 UnitsInStock from
products order by UnitsInStock desc)
Is This Answer Correct ?    4 Yes 4 No
Kaushal Gajjar
# 10
department as table name,sfee as column name
SELECT TOP (1) sfee
Is This Answer Correct ?    1 Yes 1 No

Other VB.NET Interview Questions
  Question Asked @ Answers
How to store jpeg / gif / bmp image in database and how to retrieve them? The most stressful condition is database is distributed and stored images can be retrive from any computer in network and any one can store images from other computer!! plss help its urgent.......RAHUL RATHOD   3
what is   10
Write a program that accepts an array of numbers and a number, and return a string “Yes” if the number is found in the array, “No” if the number is not found in the array.   2
code for itemstockgroupwise record?   1
Where is the Version Information Stored on a assembly ? Write the Namespace to load assemblies at runtime Can you allow a class to be inherited but prevent the method from being overridden ? What happens in memory when you box and unbox a value type ? Write a progtam to convert decimal to byte without using library function. HCL 2
Why Datareader is useful?   5
when we will use console ?   3
what are the types of threading models in ? Satyam 1
linex will support dot net? Phoenix-Technologies 4
What is JIT(Just In Time) and How it works? Infocons 5
hello dear friends my problem is that i want to save images that is pictures in SQL server using can any body help me to do so please   1
hello friends.. when i deployment my project in the client machine that is successful but whenever i try to run my project using .exe file then it gives me error "<filename>.exe is not a valid win32 application." what i do somebody halp me pls   1
For more VB.NET Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright © 2013  All Rights Reserved.   ::