My Space

Clairvoyant is one of the best MNC from baner which is US based. This is second company in 2017 that I will face f2f interview. First one was Amdocs where I failed in manager round. On friday 17th March, I was in meeting with Rohit, Our manager. The meeting was related to issues noted at chordiya jewellers. During meeting I got call from unknown number. As I was in really need of new job, I never wanted to miss any call from a unknown number. When I received call, I came to know that the call was from HR of clairvoyant . Initially , they ask regarding my job role in current company. I said all things that I do in current company i.e. manual testing, release management, customer support. Then they asked tools that I used for release management. But as my company is not using tools, I told them very clearly. Then HR told me the tool names that company is using. After hearing from them I was really shocked. In meanwhile, i was started thinking that I was not the one the company wanted...

Q. Write a query to print total number of unique hackers who made at least   submission each day (starting on the first day of the contest), and find the  hacker_id  and  name  of the hacker who made maximum number of submissions each day. If more than one such hacker has a maximum number of submissions, print the lowest  hacker_id . The query should print this information for each day of the contest, sorted by the date. Input Format The following tables hold contest data: Hackers:  The  hacker_id  is the id of the hacker, and  name  is the name of the hacker. Submissions:  The  submission_date  is the date of the submission,  submission_id  is the id of the submission,  hacker_id  is the id of the hacker who made the submission, and  score  is the score of the submission. Solutions-- SELECT a.submission_date, a.c, h.hacker_id, h.name FROM ( SELECT y.submi...

Vat baght aahe ajun pan tuzya sms chi, Khatri aahe tu mala visrnar nahi yachi... Kela nahi kadhi call, kadhi bhetlo pan nahi, Tari pan Khatri aahe tu visrli nasel yachi... Sakali uthlo ki, athvan yete tuzya tya Gm sms chi... Zoptana yete tya sweet gn8 sms chi. Khatri aahe tu visrli nasel mala yachi... Athavn yete tya khadus, manala bhidnarya shabdanchi, Khatri aahe tu mala kadhi visrnar nahi yachi... Kasa visrel te chatting mi ratri Deed paryantche. Mala Pan khatri aahe tu te visrnar nahi yachi Mala Ekvel Colleage visartil, He jag visrel. Pan khatri aahe tu visrnar nahi yachi. Ek vel dev bhaktala visrel, Pan khatri aahe tu mala kadhich visrnar nahi yachi..