-sql query based on Transaction table data with group by,sum,avg,order by.
-Python program(Find prime number),Given data set to analyze using pandas.

Question

-sql query based on Transaction table data with group by,sum,avg,order by.
-Python program(Find prime number),Given data set to analyze using pandas.

Anonym · Accepted Answer

One more question they asked
3.find the list of userid where more no of transaction today as compare yesterday

Anonym · Answer

select count(transaction_id) as no_of_trans, date, user_id
from Transaction
group by user_id, date

Anonym · Answer

lower  = int(input("enter the lowest number"))
uper = int(input("enter uper number"))

for a in range(lower,uper+1):
    if a>1:
        for i in range(2,a):
            if a%i ==0:
                break
        else:
            print(a)

Anonym · Answer

For the first round 
1. what is index different types of index?
2. primary key and unique key?
3. DDL and DML?
4.Advantage of index?
5.SQL and mySQL?
6.WHERE and having difference?
7. drop, truncate,delete?
8.normalization and advantages?

 3 questions for second round, you will be lucky if they ask you same question.

Nineleaps Technology Solutions

Frage im Vorstellungsgespräch bei Nineleaps Technology Solutions

Antworten zu Vorstellungsgespräch

Beobachtete Unternehmen

Jobsuchen