Search In
I have tables on booking orders for trips.
Bookings (booking_id, booking_time, driver_id, customer_id)
Drivers (driver_id, name)
I need to identify all customers who have had at least 60% of their bookings completed by the same driver within the last
I have a table on booking orders for trips.
Bookings (order_no, user_id, booking_time,cancel_time,complete_time)
I try to write a query to return the order_no from all rows where customers made concurrent bookings (i.e. where a customer made a new
(PL/SQL structure, Data types, Variable, DBMS Output and Conditions), try to combine the PL/SQL and the SQL, where you can use PL/SQL with SQL commands in manipulating the database. and this is my codes but i am having issues running it, ca
Hi all,
Below is an example of switching between list and grid view using jQuery.
$( document ).ready(function() {
$('.show-list').click(function(){
$('.wrapper').addClass('list-mode');
});
$('.hide-list').click(function(){
Subscribe Now to FindNerd YouTube Channel for Latest Tech Updates
As we all are living in a digital world which is so fast and changing at lightning speed each and everyday, so we need to get ourselves updated with the latest trends and te
Stored Procedures : Stored Procedures are the functions which sits on the database side and provide the services to the user by calling it. Stored Procedures are same as we like functions in our code. Stored Procedures can be created with having no p
hi all i am use tomcat 8 and my war file initially i want write a file a .properties file, here the code:
Boolean wflag = false;
String wnomfile="my.properties"
Properties prop = new Properties();
OutputStream output = null;
System.out.println(
SQL follow the unique set of rules that is called syntax ,follow the rules given below
SQL database is not a case sensitive . Generally in SQL database keywords are written in uppercase
SQL statements are dependent on text lines .
You can do task
SQL Table is used to store the data in terms of rows and column . It is the very simple form for data storage .
Example ->
**Student name** **Student Age** **Student Id**
Mukesh 23 1
Ayu
Sum ( ) , it is a function which return the aggregate sum of any expression , like salary of multiple employee , sum of population in any particular area etc .
Syntax :
select sum ( Expression ) from student where clause ; // expression can be numer
