Forum

jeevan 123
jeevan 123
@jeevan303500
Active Member
Joined: May 24, 2021
Last seen: May 17, 2022
Topics: 0 / Replies: 18
Reply
RE: Write a query to display the first and the last record from the Employee info table.

+------------+--------------+----------------+ | EmployeeId | EmployeeName | EmployeeSalary | +------------+--------------+----------------+ | 1 ...

4 months ago
Reply
RE: Write a query to display the first and the last record from the Employee info table.

select *from emp order by EmployeeId ASC LIMIT 1) UNION (select *from emp order by EmployeeId DESC LIMIT 1);

4 months ago
Reply
RE: Write a query to display the first and the last record from the Employee info table.

For last record SELECT * FROM EmployeeInfo WHERE EmpID=(SELECT MAX(EmpID) FROM Employeelnfo);  first-and-last-record-from-a-table-sql.jp...

4 months ago
Reply
RE: SQL Query to find salesmen have more than one customer

Query and the results attached. SQL Query to find salesmen have more than one customer.  salesmen-have-more-than-one-customer.jpg

4 months ago
Reply
RE: Date Conversion yyyy-mm-dd date format sql server

Date format example: SELECT FORMAT (getdate(), 'dd-MM-yy') as dateGO

5 months ago
Reply
RE: Write PL/SQL code to assign GRADE to every student based on their marks according to the following rules.

You can consider the student table for this example. Assume that It has three columns Sid, Marks and grade Create table Student ( Sid integer pr...

1 year ago
Reply
1 year ago
Reply
RE: Write a query to display the course name registered by at least two students. Sort the resultsbased on Course name.

You may also try this one. Assume that there are three tables in my database. Courses, Registration, and Students Students has StudentID, Studen...

1 year ago
Reply
RE: What is Oracle Cloud ? What are the advantages of Oracle Cloud?

Introduction to Oracle CloudThe Oracle Cloud differs from Amazon therein it's an entire integrated set of applications. Platform services and infrastr...

1 year ago
Reply
RE: Write a PLSQL program to display Welcome Message Total Salary paying to all employees and display employee name salary and designation of specific employee?

Hi Hari Priya, Please find below and let me know your thoughts. write a program to display welcome to plsql message? SQL> BEGIN ...

1 year ago