write a query for the fifth highest salary?
Answer Posted / payal
select salary from emp order by salary desc limit 4,1
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Explain the various types of normalization.
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
How to produce such kind of file?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What are the advantages of normalizing a database.
how can you perform lookup range in lookup stage expalin in detail?
What is the use of default key?
What is meant by distributed system?
define primary key index, bitmap index, hash index,virtual indwx
What is the advantage of varchar2 over char?
What is database collection?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Explain various types of locks in a transaction? Which is better and why?
can u combine pipeline parallelism and partition parallalism? how and whan?