How to select nth record from a table?
Answer Posted / veeresh kethari
select min(sal) from EMP where sal in(select top n sal from
EMP
order by SAL desc)
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is null vs coalesce?
Define self join in sql server joins?
what is a check constraint?
What is filter index?
Define cursor locking
What is the function of inner join?
Can select statements be used on views in ms sql server?
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.
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is shrink log file?
What is database replication?
Does transparent data encryption provide encryption when transmitting data across the network?
What is the meaning of resultset type_scroll_insensitive?
What are the purpose of Normalisation?
What is role playing dimension with two examples? : sql server analysis services, ssas