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
How to change the system date and time from SQL Plus Terminal ?
What will be the maximum number of index per table?
What is 2nf example?
explain different types of constraints? : Sql server database administration
Can sub report data source be different from that of the parent report?
List some advantages and disadvantages of stored procedure?
what data regions are and what are the different data regions?
How do you create an execution plan?
What are orphan records?
What is an identity?
Why are you getting errors when creating a new odbc dsn?
What does truncate do?
Explain the disadvantages/limitation of the cursor?
How many primary keys are possible in a table?
What are various aggregate functions that are available?