Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
hamza shaheen Questions
5601 Questions
Write a postgre SQL statement to insert rows into the table employees in which a set of columns department_id and job_id contains the values which must have existed into the table departments and jobs
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
118
Write a postgre query to display the names (first_name, last_name) using an alias name "First Name", "Last Name"
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
196
Write a PostgreSQL query to get a unique department ID from employee table
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
134
Write a PostgreSQL query to get the details of all employees from the employee table in descending order by their first name
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
141
Write a PostgreSQL query to get the names (first_name, last_name), salary and 15% of salary as PF for all the employees
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
120
Write a PostgreSQL query to get the employee ID, name (first_name, last_name) and salary in ascending order according to their salary
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
109
Write a postgre SQL statement to change the email and commission_pct column of the employees table with 'not available' and 0.10 for those employees whose department_id is 110
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
150
Write a postgre SQL statement to change the email column of employees table with 'not available' for those employees whose department_id is 80 and gets a commission is less than.20%
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
147
Write a postgre SQL statement to change the email column of the employees table with 'not available' for those employees who belongs to the 'Accounting' department
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
117
Write a postgre SQL statement to change the salary of an employee to 8000 whose ID is 105, if the existing salary is less than 5000
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
141
Write a postgre SQL statement to change the job ID of the employee which ID is 118 to SH_CLERK if the employee belongs to a department which ID is 30 and the existing job ID does not start with SH
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
92
Write a postgre SQL statement to create a table employees including columns employee_id, first_name, last_name, job_id, salary and make sure that,
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
0
1
174
Write a postgre SQL statement to create a table employees including columns employee_id, first_name, last_name, job_id, salary and make sure that
Postgre SQL
2022-05-18
Answers
30
Question
40
Followers
30
1
1
110
Total:
5601
Previous
73
74
75
76
77
Next
Go
