to search the data from database

by

Logic is something like that 

SELECT * FROM table  WHERE (condition)

For your case, you may as well use 

SELECT 'mobile','name','id', '...any from its table...'   FROM table_name

More Related Contents:

  1. Split comma separated values to columns in Oracle
  2. How to SELECT FROM stored procedure
  3. Oracle SELECT TOP 10 records [duplicate]
  4. What’s the best practice for primary keys in tables? [closed]
  5. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  6. What are best practices for multi-language database design? [closed]
  7. SQL Server: Get table primary key using sql query [duplicate]
  8. How to determine the number of days in a month in SQL Server?
  9. Getting all Buildings in range of 5 miles from specified coordinates
  10. Concatenate values based on ID
  11. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  12. Call a set-returning function with an array argument multiple times
  13. how to declare global variable in SQL Server..?
  14. Fastest check if row exists in PostgreSQL
  15. Disable all table constraints in Oracle
  16. Discard millisecond part from timestamp
  17. How to fill date gaps in MySQL?
  18. ORA – 00933 confusion with inner join and “as”
  19. Must declare the scalar variable
  20. Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
  21. Function for week of the month in mysql
  22. How to get the identity of an inserted row?
  23. SQL column reference “id” is ambiguous
  24. How to extract group from regular expression in Oracle?
  25. Rails find record with zero has_many records associated [duplicate]
  26. Finding a Top Level Parent in SQL
  27. How to get results in a custom order? [closed]
  28. Call stored procedure with table-valued parameter from java
  29. SQL select * from column where year = 2010
  30. Oracle IN vs Exists difference?

Leave a Comment