Select Statement in SQL

Select statement is most used command in SQL. It is used to fetch data from table and display data in tabular form.

The syntax of select statement is:

SELECT *FROM Table_Name;

Suppose we have a below EMP table

Emp_ID	Emp_Name	Emp_Age	Emp_Salay
1	Mohan	25	25000
2	Rakesh	25	25000
3	Ram	25	25000

Now we have above table which is already created and now we want to fetch all table data from above table so for this we use below Select statement to retrieve

SELECT Statement to retrieve Data from EMP table:

SELECT *FROM EMP;

Now after executing this command , the output will be :

Emp_ID	Emp_Name	Emp_Age	Emp_Salay
1	Mohan	25	25000
2	Rakesh	25	25000
3	Ram	25	25000

Comments

How to analyze a JMeter summary report?

A Jmeter Test Plan must have listener to showcase the result of performance test execution. Listeners capture the response coming back from Server while Jmeter runs and showcase in the form of – tree, tables, graphs and log files. It also allows you to save the result in a file for future reference. There are many types of listeners Jmeter provides. Some of them are: Summary Report, Aggregate Report, Aggregate Graph, View Results Tree, View Results in Table etc. Here is the detailed understanding of each parameter in Summary report. By referring to the figure: Label : It is the name/URL for the specific HTTP(s) Request. If you have selected “Include group name in label?” option then the name of the Thread Group is applied as the prefix to each label. Samples : This indicates the number of virtual users per request. Average : It is the average time taken by all the samples to execute specific label. In our case, the average time for Label 1 is 942 milliseconds & to...

What is usability testing ?

What is usability testing ? Usability testing is a way to see how system is easily usable by the end users. It basically verifies the interface of website and test whether application is user friendly or not. It identifies how the customer will feel comfortable in using the software. Usability Testing not only test Look and feel it also test in how many steps customer will reach their goals Example: Suppose there is an application in which user wants to generate Attendance Report of Employees on daily basis, and user has to follow below steps: 1) Login to Application. 2) Click on Attendance System 3) Click on Reports and select Employee Attendance Report 4) Various Employee Attendance reports will be displayed of different teams. Select particular report(say: Select Team) 5) Select the parameters which you want to display in report say: • Date • Shift Timings • Employee Id • Name • In/Out Time • Status (Present/Absent/leave) 6) Click on Generate Report 7) Click on Print option In this ...

Soft-QA

Search This Blog