Register Now

By registering, you agree to the terms of service and Privacy Policy.

Login

Forget

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

x

Login

Forget

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Create an account
x
You can use WP menu builder to build menus
Ask a Question
0
  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

The Data Monk

  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

About Pranavb13 Member

Pranavb13
  • Registered: June 6, 2020
  • Phone: 07988686937
  • Country: India
  • City: Ambala Cantt
  • Gender: Male

User Stats

  • Questions ( 0 )
  • Answers ( 9 )
  • Asked Questions ( 0 )
  • Posts ( 0 )
  • Comments ( 0 )
  • Best Answers ( 0 )
  1. SQL Interview question

    Pranavb13
    Pranavb13 Member
    3
    June 7, 2020 at 4:42 pm
    SELECT name FROM student WHERE LEN(name)=10 AND name LIKE ‘K
  2. Write a SQL query to find all the student names Nitin in a table

    Pranavb13
    Pranavb13 Member
    4
    June 7, 2020 at 4:40 pm
    select name from student where lower(name) like ‘%nitin%’ ;
  3. Can you use HAVING command without any aggregate function in SQL?

    Pranavb13
    Pranavb13 Member
    1
    June 7, 2020 at 4:32 pm
    select id, count(id) from book having id < "10"
  4. SQL interview Question | Second Highest Salary – Method 1

    Pranavb13
    Pranavb13 Member
    3
    June 7, 2020 at 4:31 pm
    SELECT Name, MAX(salary) AS salary FROM Table WHERE salary
  5. SQL interview question | Write the query

    Pranavb13
    Pranavb13 Member
    4
    June 7, 2020 at 4:28 pm
    SELECT (Revenue – Cost Price) AS Profit FROM table ;
  6. What is the order of execution of SQL commands?

    Pranavb13
    Pranavb13 Member
    0
    June 7, 2020 at 4:27 pm
    Order of execution for an SQL query 1. SELECT 2. FROM 3. WHE
  7. What is the order of execution of SQL commands?

    Pranavb13
    Pranavb13 Member
    4
    June 7, 2020 at 4:26 pm
    Order of execution for an SQL query SELECT 1) FROM 2) WHERE
  8. SQL interview Question | Second Highest Salary – Ranking

    Pranavb13
    Pranavb13 Member
    2
    June 7, 2020 at 4:24 pm
    select * from ( select e.*, rank() over (order by salary des
  9. What is the use of OFFSET command?

    Pranavb13
    Pranavb13 Member
    7
    June 6, 2020 at 2:40 pm
    Both MySQL and PostgreSQL support a really cool feature call

Products

  • Mentorship Program for Analytics interview 1 Month Analytics Mentorship Program ₹11500 Original price was: ₹11500.₹9999Current price is: ₹9999.
  • The Data Monk e-book bundle The Data Monk 23 e-book bundle ₹6900 Original price was: ₹6900.₹1999Current price is: ₹1999.
  • Most asked Analytics Interview Questions 2200 Most Asked Analytics Interview Questions ₹7999 Original price was: ₹7999.₹1999Current price is: ₹1999.
  • Analytics Interview Book Bundle Cover Page 10 Books to crack Analytics interview ₹2999 Original price was: ₹2999.₹999Current price is: ₹999.
  • Machine Learning Interview Questions Machine Learning 1200 Interview Questions ₹3600 Original price was: ₹3600.₹999Current price is: ₹999.
  • 30 Days Analytics Course 30 Days Analytics Course ₹1999 Original price was: ₹1999.₹999Current price is: ₹999.
  • Business Analyst Most Interview Questions 1250+ Business Analyst Most Interview Questions ₹1299 Original price was: ₹1299.₹899Current price is: ₹899.
  • Crack Any Data Analyst Interview with 1100 Questions Crack Any Data Analyst Interview with 1100 Questions ₹1999 Original price was: ₹1999.₹799Current price is: ₹799.
  • Ace The SQL Interview Ace The SQL Interview | 200+ Most Asked SQL Questions in Top Product Based Companies ₹1299 Original price was: ₹1299.₹799Current price is: ₹799.
  • 550 SQL Interview Questions to crack Any Analytics interview 550 SQL Interview Questions to crack Any Analytics interview ₹999 Original price was: ₹999.₹499Current price is: ₹499.
  • Crack your next Data Science interview with 300+ Questions Crack your next Data Science interview with 300+ Questions ₹499 Original price was: ₹499.₹299Current price is: ₹299.

Stats

  • Questions ( 1784 )
  • Answers ( 2722 )
  • Best Answers ( 92 )
  • Users ( 24986 )
Copyright 2020 Ask me | By 2code
  • Login
  • Sign Up
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }