Answer Posted / amruta dash
select max(salary) from tblname where salary not in (select
max(salary) from tblname);
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
What is the difference in accessing db between sql server vs sql azure?
What is 2nf normalization form?
What is b tree index?
Can a table be created inside a trigger?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Explain forward - only cursors?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How can sql injection be stopped? : sql server security
What is table join?
What happens if strings are casted into wrong code pages in ms sql server?
What is always encrypted?
What are the tables in sql?
Define magic tables in sql server?
What is mean by dml?