SQL Queries Basics

I have a table named Jobs which contains the data of different jobs on a JobPortal. How do I find the number of rows in the table?

• Select count(*) from jobs;

• make count(*) from jobs;

• insert count(*) from jobs;

• delete count(*) from jobs;

If we wanted to know the names of all distinct companies in the Job table alphabetically - which of the following queries will do the Job?

• Select distinct company from jobs order by company

• select distinct company from jobs order by 1

• select distinct company from jobs order by company desc

• order by company select distinct company from jobs

The function to get the total of a column in MySQL is?

• SUM

• ADD

• Total

• None of the above

In our Jobs table, what will be the query if I want to get the total ctc given in all the jobs and put it in a variable named total_ctc in the final results?

• Select total(ctc) from jobs;

• select sum(ctc) as total_ctc from jobs

• select total(ctc) as total_ctc from jobs

• Both b & c

Let’s say in the previous example, I want to know the highest and lowest value of ctc in the table. What will the query look like?

• Select low(ctc) as lowest_salary,high(ctc) as highest salary from jobs

• Select min(ctc) as lowest_salary,max(ctc) as highest salary from jobs

• Select lowest(ctc) as lowest_salary,highest(ctc) as highest salary from jobs

• None of the above

Suppose in the table Assignment as we had used in the videos of this module, I want to know the total salary of Pooja Mishra and Sneha. Which of these queries will work fine?

• select sum(salary) from assignment where name='Pooja Mishra' and name = 'Sneha'

• select sum(salary) from assignment where name='Pooja Mishra' or name = 'Sneha'

• select sum(salary) from assignment where name in 'Pooja Mishra' ,'Sneha')

• select tot(salary) from assignment where name in 'Pooja Mishra' ,'Sneha')

The options IN, OR, NOT, AND, BETWEEN are applied to

• Group by clause

• Where clause

• Get

• Nest

The way to display/get partial results from a query is?

• Select

• limit

• getsome

• partial

Suppose I want to select the last 10 rows of a dataset / table. Given that the dataset is sorted in the increasing order of jobid. What will the query look like?

• Select * from jobs order by jobid desc limit 10

• Select * from jobs order by jobid asc limit 10

• Select * from jobs limit 10

• Select * from jobs where limit 10

Suppose I want to select the row with second highest ctc. What will the query look like?

• Select * from jobs order by ctc desc limit 1 offset 1

• Select * from jobs order by ctc asc limit 1 offset 1

• Select * from jobs order by ctc desc limit 1 offset 2

• Select * from jobs order by ctc asc limit 1 offset 2