what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 14601If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
9 16128Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
3 10516source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
4 11982Post New JPMorgan Chase SQL PLSQL Interview Questions
What is non verbal communication?
How to assign a table row to a record variable?
Hi, Can somebody help me to know whether WCT MVAt is applicable on catering service, if the caterer is uses his own material and labour for doing cooking in our premises and later the product is sold in the same premises for the employees. Kinldy advice whether WCT will be deducted on this.
How would you convert a string into an int in python?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
Compare the features of the three transistor configurations.
How to calculate the amount for 1000 rs
What is assign property in objective c?
What are different isolation levels?
While I prepare Form JJ for goods transfer I made a mistake that the value of goods is morethan the actual value(i.e. instead of Rs.92100/- I filed Rs.1354000/-)and the copy of JJ sheet is sealed in the checkpost one copy is taken in the checkpost. please anybody give me the exact solution. thanks
What are the types of servers?
Explain the advantages/disadvantages of logical databases?
Why session is required?
Define acquired immunity.
What is the vector for rocky mountain spotted fever?