write query for fourth maximum salary from employee table
Answer Posted / elumalai.k
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What have included columns when we talk about sql server indexing?
What is a transactions?
Can we call stored procedure in trigger?
How to list all dsn entries on your local machine using odbc_data_source()?
How to set the current database in ms sql server?
What are translations and its use? : sql server analysis services, ssas
How many partitions a clustered index has by default in sql server 2012?
Disadvantages of the indexes?
Can an entity have two primary keys?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
plss anybody specify tha constrian management system in dbms
Can we take the full database backup in log shipping?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
Describe how to use linked server?
What is transaction server implicit?