User Answer - The Data Monk

SQL interview Question | Second Highest Salary – Ranking
Prerana
0
January 21, 2023 at 11:03 am
SELECT EMP_ID, NAME, SALARY FROM (SELECT SALARY, EMP_ID,NAME
Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).
Prerana
0
January 17, 2023 at 4:27 pm
SELECT STUDENT_NAME FROM STUDENT_TB WHERE UPPER(GENDER) IN(‘
Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).
Prerana
0
January 17, 2023 at 4:27 pm
SELECT STUDENT_NAME FROM STUDENT_TB WHERE UPPER(GENDER) IN('
D Cube Analytics Interview Question | Duplicate Rows
Prerana
0
March 22, 2022 at 9:56 am
By using distinct() window function on column that has uniqu
Find the 4th Highest employee salary from the following table
Prerana
0
March 22, 2022 at 9:47 am
SELECT salary FROM (SELECT *, DENSE_RANK() OVER (ORDER BY SA
Tiger Analytics Interview Question | Duplicate Entries
Prerana
0
March 22, 2022 at 9:43 am
You can using DISTINCT(), this will return only the unique v
Cisco Interview Question | Query I
Prerana
0
March 10, 2022 at 2:01 pm
CREATE table emp_new as ( SELECT emp_id,joining_date, salary
SAP interview Questions | Grouping Users
Prerana
0
March 10, 2022 at 1:38 pm
We can use this data for Customer Segmentation 1. Based on t
SQL Interview Questions | Alternative of TOP Clause
Prerana
0
February 24, 2022 at 5:27 am
We can use ORDER BY followed by LIMIT IF YOU WANT TOP N USE
SQL Interview Questions | Nth Highest Salary
Prerana
0
February 23, 2022 at 3:28 pm
THIS WILL GIVE DUPLICATE VALUES TOO SELECT * FROM (SELECT *,

About Prerana

User Stats

SQL interview Question | Second Highest Salary – Ranking

Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

Find all the students who either are male or live in Mumbai ( have Mumbai as a part of their address).

D Cube Analytics Interview Question | Duplicate Rows

Find the 4th Highest employee salary from the following table

Tiger Analytics Interview Question | Duplicate Entries

Cisco Interview Question | Query I

SAP interview Questions | Grouping Users

SQL Interview Questions | Alternative of TOP Clause

SQL Interview Questions | Nth Highest Salary

Register Now

Login

Lost Password

About Prerana

User Stats