Forum

jeevan 123
jeevan 123
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 ...

3 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);

3 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...

3 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

3 months ago
Topic
Topic
Replies: 1
Views: 180
Reply
RE: Date Conversion yyyy-mm-dd date format sql server

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

3 months ago
Topic
Topic
Replies: 1
Views: 139
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
Page 1 / 2