Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kavitha
select max(salary) from tablename where salary not in(select
max(salary) from tablename )
or
select max(salary) from tablename where salary <(select
max(salary) from tablename )
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Write an sql query to find first weekday of the month?
What is the default order of an order by clause?
Explain what are commit and rollback in sql?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
List down some advantages of sql stored procedure?
Explain about merge replications?
what are the critical issues you have resloved in your company
How do I port a number to sql server?
What is log in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Write a sql query to delete duplicate records from a table called table1
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is the purpose of grouping data in a report?
