Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
920If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
894Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
926Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
844Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
964
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
Is mysql deprecated?
What is the difference between database and table?
How to delete an existing column in a table?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What is the default port number of mysql?
How to check server status with 'mysqladmin'?
What is prepare statement in mysql?
What does mysqli stand for?
What is the datatype for password in mysql?
How do you stop an access query?
What is difference between mysql and mysql server?
How do I view mysql logs?
What is mysql in dbms?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba