can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
Answer Posted / elumalai.k
select max(salary)from tablename where salary <(select
max(salary)from tablename)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does Master database contains?
What is the bookmark lookup and rid lookup?
How to transfer an existing table from one schema to another schema in ms sql server?
What is the difference between a primary key and a unique key? Are they the same?
What are the new features in sql server 2016?
How to use "begin ... End" statement structures in ms sql server?
What is sleeping status in sql server?
How does index makes search faster?
Do you know what is normalization of database? What are its benefits?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is "scheduled jobs" or "scheduled tasks"?
How to count duplicated values in a column in ms sql server?
Why I am getting this error when dropping a database in ms sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Write a SQL queries on Self Join and Inner Join.