What is the difference between inner and outer join? Explain with example. Inner Join Inner join is the most common type of Join which is used to combine the rows from two tables and create a result set containing only such records that are present in both the tables based on the joining condition (predicate).
To find GCD of two numbers To find the lcm of two numbers To find the Factorial of a non negative number To find the area of a circle (area=3.14rr), when diameter is given. To find the area of triangle when base and height is given. To print the Fibonacci series.Input=6 Output=1 1 2 3
1.The water from one outlet, flowing at a constant rate, can fill the swimming pool in 9 hours. The water from second outlet, flowing at a constant rate can fill up the same pool in approximately in 5 hours. If both the outlets are used at the same time, approximately what is the number of
All Company Wise Question Will be Available on Nileshblog.tech and Technilesh.com DIRECTIONS: Read the following given below and answer the questions that follow.i) Eleven students Anwar, Baham, Chetan, Dayal, Eshwar, Farooq, Gajendra, Hariom, Inayat,Jatin and Kishore are sitting on a bench in a lecture room facing towards the teacher.ii) Dayal is towards the left of
Given two sorted arrays nums1 and nums2 of size m and n respectively, return the median of the two sorted arrays. The overall run time complexity should be O(log (m+n)). Example 1: Input: nums1 = [1,3], nums2 =  Output: 2.00000 Explanation: merged array = [1,2,3] and median is 2. Example 2: Input: nums1 = [1,2], nums2 = [3,4] Output: 2.50000 Explanation: merged array = [1,2,3,4]
Information Technology has taken the world by storm. No office or organization can function without the assistance of the IT department. This global phenomenon is certainly attracting a massive number of students every year. As the number of IT enthusiast students increases, the number of IT colleges is also increasing. In the context of Nepal,
The University of Pune has asked for police security at 900 test centers spread over three districts.
PUNE The semester examinations at Savitribai Phule Pune University (SPPU) will begin in offline mode on June 20. Uniformity in the administration of the tests has been a source of contention among different student unions and organizations. In the midst of this, the SPPU has submitted letters to the commissioners of police in each of
AICTE reports that the average math performance of first-year engineering students is below 40%. According to a study conducted by the All India Council for Technical Education (AICTE), first-year engineering students struggle with arithmetic more than any other major subject, a finding that highlights the country’s engineering education crisis. The survey, which was conducted to
Savitribai Phule Pune University (SPPU) will begin accepting applications for diploma, degree, and post-graduation programmes on Wednesday (June 15). According to authorities, admission tests will be held in the next month. On Monday, the university’s admissions department released a comprehensive admissions calendar for at least 2,500 seats. The tentative dates for the entrance tests are
PUNE With most schools in Pune resuming on Monday, June 13, school administrators are preparing to welcome pupils back while also making safety preparations in light of the state’s growing number of Covid-19 cases. Suraj Mandhare, the state education commissioner, has issued a circular instructing all schools and education departments to celebrate the first two
- TCS and Infosys Database , SQL questions | TCS and Infosys Technical Round Question
- TCS and Infosys Coding Question | TCS and Infosys placement prepration
- Infosys and TCS Aptitude and logical reasoning question set 2 | Company wise Question
- Infosys Aptitude and logical reasoning question set 1 | Company wise Question
- leet code median of two sorted array Java ,C++ ,C, JS solution