
Last seen: May 17, 2022
+------------+--------------+----------------+ | EmployeeId | EmployeeName | EmployeeSalary | +------------+--------------+----------------+ | 1 ...
select *from emp order by EmployeeId ASC LIMIT 1) UNION (select *from emp order by EmployeeId DESC LIMIT 1);
For last record SELECT * FROM EmployeeInfo WHERE EmpID=(SELECT MAX(EmpID) FROM Employeelnfo); first-and-last-record-from-a-table-sql.jp...
Query and the results attached. SQL Query to find salesmen have more than one customer. salesmen-have-more-than-one-customer.jpg
Date format example: SELECT FORMAT (getdate(), 'dd-MM-yy') as dateGO
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...
Query to display the booking and the payment made by the guest. Display guest name, resort name, from date, to date, adult count, child count, and tot...
Let us consider the employee table for our scenario. It has five columns like EMPID, EmpName, Salary, and Dept Employee: Column_Name DataType Cons...